In attached, I need to bypass "SORTBY" so I have to di=o it different way...
I need to sort B:C, by C ascending
I did C ascending in E
I need at F4 to sort B too
In attached, I need to bypass "SORTBY" so I have to di=o it different way...
I need to sort B:C, by C ascending
I did C ascending in E
I need at F4 to sort B too
How about
=INDEX($B$4:$B$23,AGGREGATE(15,6,(ROW($B$4:$B$23)-ROW($B$4)+1)/($C$4:$C$23=E4),COUNTIF(E$4:E4,E4)))
Thank you very much !
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks