Hello guys,
Could really use some help with a problem in Excel.
Lets say I have a text and a quantity as seen below
Hello 3 Good bye 4 Good night 2
Is there any easy way to multiply the text with the quantity to get a list as seen below?
Hello Hello Hello Good bye Good bye Good bye Good bye Good night Good night
Thanks in advance!
Try this:
Array formula must be confirmed with Ctrl+Shift+Enter key combination
=IFERROR(INDEX($A$1:$A$3,MATCH(TRUE,MMULT(--(ROW($A$1:$A$3)>=TRANSPOSE(ROW($A$1:$A$3))),$B$1:$B$3)>=ROWS($1:1),0)),"")
Hello Hello Good bye Hello Good night Hello Good bye Good bye Good bye Good bye Good night Good night
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
A coded solution.
Input A1:B2 output from G1
Please Login or Register to view this content.
Wow that was a long formula
Unfortunetly I could not get it to work in Excel 2007
***Array formula must be confirmed with Ctrl+Shift+Enter key combination
Also, maybe in your region commas need to be replaced with ;
Thank you, that worked super!Originally Posted by Andy Pope
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks