Hi Rathanak Glad to know it helps. There are always more than one way to solve a problem. It doesn't matter if it is a long/short/fantastic/fast...
Hi Frans It was way pass midnight over here when I posted that long explanation. I have attached the working for better clarification. Hope t...
Hi Frans It is not easy to explain the workings but I will try my best. I have broken down the formula for easy reference. Note : A2 = Meal Type...
Hi again rathanak Try this: =INDEX({30,40,50},MATCH(A2,{"Breakfast","Lunch","Dinner"},0))*(MIN(INDEX({6,7,4},MATCH(A2,{"Breakfast","Lunch","Dinn...
Hi Frank Give this a try =MROUND(ABS(SUM([@[goods value]]*0.2)),0.05)*SIGN([@[goods value]]) Sunny Kow
Very interesting. I am sure this will be very useful for me in the future. Thanks Philip Sunny Kow
You can choose the UDF way : Function Allowance(NoOfDays) Select Case NoOfDays Case Is <= 5 Allowance = NoOfDays * 40 Case Is <= 10 Allow...
Hi TimC There is no attachment. Based on your description, you could use the AGGREGATE or SUBTOTAL function. Both can handle filtered data. H...
Hi Amy Give this a try. It is a bit long (no idea how to shorten it) but it should work. Modified it based on Catalin's original formula. =I...
Hi Mynda It would be good if the cells was renamed NI,TI etc so that the formula can be clearer =(NI*TI)/NA/(BT-BA) The answer given in by yo...
Hi James Why don't you drop the Hrs/Load field into the Values area and Summarize Values By Average? It will give you the same answer as your AV...
Hi DonW I would suggest creating a Pivot Table with your Table names and use a slicer to select it instead of using data validation. Based on wh...
Hi Mynda If I have a unique key e.g. cheque no., I would prefer using a Pivot Table. This allows me to see all matched and unmatched transactions. ...
Hi Amy Based on Craig's formula, you could also simplify to: =IF(W6="box",IF(LEFT(I6,3)="RSC","half label",IF(I6="DIRECT","4x3 label",IF(I6="DIR...
Hi Tony This will will surely work and it can handle any variation Function skCountWeeks(MyRange As String) Dim WeeksArray() As String Di...