Hi, in Column A, i have currency. in B, i have the number of times the currency repeat. While in Column F show the final result. Example, GBP 2 mean F2 and F3 is GBP GBP. WHat formula should i used? Refer attachment for a better understanding.
Hi, in Column A, i have currency. in B, i have the number of times the currency repeat. While in Column F show the final result. Example, GBP 2 mean F2 and F3 is GBP GBP. WHat formula should i used? Refer attachment for a better understanding.
Look at COUNTIF
Misread the requirement!
Last edited by JohnTopley; 10-03-2017 at 03:41 AM.
f2=IF(ROWS(F$2:F2)>SUM(B$2:B$5),"",LOOKUP(ROWS($F$2:$F2),MMULT(((ROW($B$2:$B$5)>=TRANSPOSE(ROW($B$2:$B$5)))+0),$B$2:$B$5)-$B$2:$B$5+1,$A$2:$A$5))
Try this array formula (confirm with shift+ctrl+enter) and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
or
f2=IFERROR(INDEX($A$2:$A$5,MATCH(1,INDEX((COUNTIF($F$1:$F1,$A$2:$A$5)<$B$2:$B$5)+0,0),0)),"")
Try this and copy towards down
Posted to wrong thread.. Sorry.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks