Hey there,
I'm hoping to get some help with an excel sheet I'm working on.
I'm trying to get cells to copy into another table based on the rank determined in the table previously. I was trying to adapt a VLOOKUP to do the work for me but I cant seem to get it right.
Its important that the cells automatically fill and change based on the rest of the document being modified, no use of the sort feature.
I'll attach a copy of the document in case anyone has any suggestions and can tell me how to get there.
Thanks so much in advance
**in doc**
I want the cells W4-W10 to fill from C4-C10 based on the cells from U4-U10 in order from smallest to largest. And for cells from U4-U10 to fill X4-X10 from order of smallest to largest.
Hi Tony,
Put this formula in V4 and copy the cell to V10:
=RANK(T4,T$4:T$10,1)+COUNTIF(T$4:T4,T4)-1
This will create a rank without duplicates.
Now, you can use a simple formula to get the sorted list of stores in W4:
=INDEX(C$4:C$10,MATCH(ROW(A1),V$4:V$10,0))
