Mr Football
New Member
- Joined
- Sep 16, 2018
- Messages
- 2
So I ahve made some progress with the ballot for this coming Saturdays car show. Problem is the formula I use lists the word Tie when there is a tie. I just want it to list the top finisher (30 to be exact) even if ther are ties.
Here is the formula.
=IF(LARGE(AA$2:AA$531,LEFT($A3,1)+0)=0,"",IF(COUNTIF(AA$2:AA$531,LARGE(AA$2:AA$531,LEFT($A3,1)))>1,"Tie",INDEX($X$2:$X$531,MATCH(LARGE(AA$2:AA$531,LEFT($A3,1)+0),AA$2:AA$531,0))))
Here is the formula.
=IF(LARGE(AA$2:AA$531,LEFT($A3,1)+0)=0,"",IF(COUNTIF(AA$2:AA$531,LARGE(AA$2:AA$531,LEFT($A3,1)))>1,"Tie",INDEX($X$2:$X$531,MATCH(LARGE(AA$2:AA$531,LEFT($A3,1)+0),AA$2:AA$531,0))))
