RANK Formula vs Last year

[bjbboats]

Hi

In the attached spreadsheet I'm looking for something to be included in the rank formula so if there's nothing to compare to in the previous year it just includes it's current rank position in the cell.

Hopefully makes sense.

Thanks

[daddylonglegs]

Try this version in D6 copied down

=RANK(H6,H$6:H$30)&IFERROR("("&RANK(VLOOKUP(C6,M$6:P$30,4,0),P$6:P$30)&")","")

[bjbboats]

Perfect thanks