lundi 26 janvier 2015

If a certain placing, then place the athletes name

I would like to provide the name of the competitor if they placed first. In different cells, I will like the same for second place to fifth place.


My purpose is because there are many divisions, 27, and each are on different worksheets. It would make it easier to have all the top five division placings on one sheet for the announcer and passing out trophies.


I am unable to provide a picture until I have a rep of 10. Therefore, the data is provided below.


Thank you so much for your time and help!


Column B Competitor Name



  1. Brown, Sam

  2. Simmons, Donald

  3. Smith, John

  4. Doe, John

  5. Lee, Joe

  6. Smith, Joey

  7. Smith, Joey

  8. Smith, Joey


Column C Placings



  1. 5

  2. 4

  3. 2

  4. 6

  5. 8

  6. 7

  7. 1

  8. 3


Aucun commentaire:

Enregistrer un commentaire