SunnyKow said Hi again rathanak Try this: =INDEX({30,40,50},MATCH(A2,{"Breakfast","Lunch","Dinner"},0))*(MIN(INDEX({6,7,4},MATCH(A2,{"Breakfast...
Thanks,I use if condition I never use UDF SunnyKow said You can choose the UDF way : Function Allowance(NoOfDays) Select Case NoOfDay...
Mynda Treacy said Hi Rath, Rather than over complicate the formula I'd just create a single column. Convert Credits to negative values so you can ...
DBuck said Thank you Mynda, that is very helpful. Dave Dear Mynda, If different column,i mean amount in Dr column nd Cr Column,how can we t...
U Catalin Bombea said Hi Frans, welcome to our forum 🙂 Sorry I puzzled you. I admit I wrote the first one just for fun 🙂 First, make su...
Mynda Treacy said Hi Rath, What do you mean by 'elaborate'? Is the formula not working? You can learn more about the AGGREGATE function here an...
I Catalin Bombea said Hi Rathanak, You can try one of these: =AGGREGATE(15,3,ROW($A$10000:$A$60000)/((ROW($A$10000:$A$60000)>=A1)*...