Detectiveclem
Active Member
- Joined
- May 31, 2014
- Messages
- 320
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hi,
I am using the following formula to place individuals 1st, 2nd or 3rd depending upon their score.
=IFERROR(OFFSET($G5,MATCH(LARGE(K5:K17,3),K5:K17,0)-1,0),"")
All works well, until I have two or more people with the same top score, I.E. 1st place is Annabel with 45, then John with 43 is second, however if Adnan also has 43 points, then my formula simply show Annabel is 1st and then John as 2nd and also 3rd place, no mention of Adnan. Can anyone assist me so that I have simply 1st and 2x 2nds (these seconds could simply be shown together) in this scenario and then a 3rd with the next score down (or wherever the the duplication appears).
I hope I have explained my issue
I am using the following formula to place individuals 1st, 2nd or 3rd depending upon their score.
=IFERROR(OFFSET($G5,MATCH(LARGE(K5:K17,3),K5:K17,0)-1,0),"")
All works well, until I have two or more people with the same top score, I.E. 1st place is Annabel with 45, then John with 43 is second, however if Adnan also has 43 points, then my formula simply show Annabel is 1st and then John as 2nd and also 3rd place, no mention of Adnan. Can anyone assist me so that I have simply 1st and 2x 2nds (these seconds could simply be shown together) in this scenario and then a 3rd with the next score down (or wherever the the duplication appears).
I hope I have explained my issue