Thread: Ranking
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
danielocope danielocope is offline
external usenet poster
 
Posts: 10
Default Ranking

Sandra

That Pivot Table stuff may be what you are looking for, but I think you
wanted something a bit easer to understand, if not OK pivot away, if so try
this simple formula in column C,,
=IF(B2<=A2,A2,0)
=if the number in B2 is greater than the number in A2 show the number in A2
other wise show 0.

Good Luck
Dan
Please rate this response, thank you!


"SBárbara" wrote:

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