dep

Hi all I am trying to create a series of dynamic lists with data from a table searching on 1 criteria to return a second set of data Example data set Make Item 200mm ICP module 300mm DEP module 200mm DSiv module 200mm DEP module 300mm Synapse module 200mm DEP...

Hi everyone,:) Let say, I have a daily production related to 5 unique departements. (dep 1, dep 2, dep 3, dep 4, dep 5), . each of these deps, are manually entered in a table main master sheet on a daily regular basis. The required task is this: How can I get each of these...

I am only just starting to learn how to do VBA Excel macrosand I would like to create a macro to do the following: If I have rows of data as follows (simplified), in a sheet called "Dependencies": Column: A B C D E F...

I've been trying to figure out the best way to get data based on a current date and typically use vlookup but it won't allow 12 conditional statements to look at each month. I want to populate based on the current date retrieving from tables from each month assuming the table was extended out...

good day all, i need some macro to show me the reverse of current applied filter. For example i have a table and one column in table shows Dep A, Dep B, Dep C, Dep D etc. i apply filter on this column for Dep A and Dep C..... So Dep B and Dec D will be hidden. From here, i need a macro which...

Below is the Raw bank statement <tbody> Book Date Transaction Type Settled Amount Bank Reference All Transaction Details 4/9/2018 I/W RTGS PAYMTS 100 aaaaaaaaa asasdsasadasdsadasdasddsadasdasds 4/10/2018 NEFT INWARD 200 aaaaaaaaa asasdsasadasdsadasdasddsadasdasds 4/10/2018 TDS ON DEP...

Hello ! I am trying to make a counting for unique value on the same date. I've seen several formulas here and it's too complex for me to understand :(. Staff record ( Sheet 1 ) <tbody> A B C D 1 Date Staff Dep Quantity Wa Quantity 2 12/1/2017 Alex Expected value 1 Expected Value 1 3...

I am using the below formula to return the smallest number in a range. =SMALL(IF('YoY View - Dep & Cat'!$D$6:$D$108='Call Outs'!$C$4,'YoY View - Dep & Cat'!$U$6:$U$108),$B5) I would like to return the label of the result, I'm having difficulty doing so. For example the above formula would...