I am sending an example in attach. For each "prova" i need to get the lesser
time and the name of the person who has this time. Can you help me?

Prova Atleta Tempo
50 m Livres Adriano José Ramos 00:45,82
50 m Costas Alexandra Alves Vieira 00:58,89
100 m Costas Alexandra Machado 01:51,44
100 m Costas Alexandra Machado 01:46,21
100 m Livres Alexandra Machado 01:45,75

Regards,
Sandra Bárbara

"danielocope" escreveu:

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