Is this doable?
Let's say that i have 5,10,15 and 10 HotDogs, 25 HotDogs and 50 HotDogs stated in other 3 cells. I know i could do it cell by cell, but I'd like to do it with a shorter formula (there will be more values than just 3 in an array).Please Login or Register to view this content.
Thanks
does the job but only for the first couple of cells in the array - it ignores all other.Please Login or Register to view this content.
Bookmarks