Thread: Ranking
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Ranking

Sandra,

Use a Pivot Table: Select the table, then choose Data / Pivot Table.... and click Finish. Then
drag the column A header to the Row Fields area, and the column B header to the data fields area,
right-click on the column B header tab on the pivot table, choose Field Settings, and choose Min.

HTH,
Bernie
MS Excel MVP


"SBárbara" wrote in message
...
Hi, I need some help...

I have a database with two columns - A and the B - and want to get the data
of the column A (not repeated) with the lesser value of column B.

Best Regards,

Sandra Bárbara