View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Help with SMALL formula.

I have a range of 144 rows. A1:A144 contain names, B1:B144 contain values.
I've successfully used the SMALL formula to sort the data 1 through 144, but
I'd like to reference the corresponding names with the values. How do I do
that?