I found the following formula on another thread and it works perfectly until I get to a second listing of the same item.
=IF(COUNTIF($E$5:E5,E5)=INDEX(B:B,MATCH(E5,A:A,0)),INDEX(A:A,MATCH(E5,A:A,0)+1),E5)
Example:
Item # of occurrences
Sugar Melt 3
Summer Beauty 1
Blue Ice 1
Sugar Melt 1
Hot Lips 1
I want it to be listed this way:
Sugar Melt
Sugar Melt
Sugar Melt
Summer Beauty
Blue Ice
Sugar Melt
Hot Lips
But when it gets the the second Sugar Melt the formula will only return Sugar Melt. Is there a way to fix this?
This is part of a larger workbook so the Items are extracted from another sheet and will not be combined or sorted in this list.
I have attached a workbook with more detail.
Bookmarks