Try this in B1:

=IF(MOD(ROW(),3),RANK(A1,(A$1:A$2,A$4:A$5,A$7:A$8, A$10)),"")

Copy down to B10

Biff

"casdaq" wrote in message
...
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.