Here's another one...
=IF(LEN(D3),INDEX(NAME,SMALL(IF(CHARGE2=D3,ROW(CHARGE2)-MIN(ROW(CHARGE2))+1),COUNTIF(D$3:D3,D3))),"")
Still array entered.
Here's another one...
=IF(LEN(D3),INDEX(NAME,SMALL(IF(CHARGE2=D3,ROW(CHARGE2)-MIN(ROW(CHARGE2))+1),COUNTIF(D$3:D3,D3))),"")
Still array entered.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks