hi all,
so I am building a racing scoring chart, I need to range a set of cells and bring back the order of placings, but I also need to show the following when they appear
- "DNF" needs to read as "DNF"
- "DNS" needs to read as "DNS"
- when it is blank it will error so I have written an error formula to avoid this, I would like to write something else like an IF that vbrings back "" if it errors
The current formula I have works for everything but "DNS"
=IFERROR(IF(J3="DNF",J3,RANK(J3,$J$3:$J$32,1),"")
If someone could help with this i would be most grateful.
James
Bookmarks