I have a worksheet with data in column a1:a10 and a ranking column in b1:b10.
I need to skip ranking a3, a6 and a9 but I need to leave the data in the
cells the way they are. What function can I use to do this? The Ranking
function doesn't seem to like skipping cells.