In D6 this: =MATCH(B6,$A$6:$A$14,0)
In C6 this: =INDEX($A$6:$A$14,SMALL($D$6:$D$10,ROW(A1)))
copy both down
In D6 this: =MATCH(B6,$A$6:$A$14,0)
In C6 this: =INDEX($A$6:$A$14,SMALL($D$6:$D$10,ROW(A1)))
copy both down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks