Do you mean something like this:

=IF(F26="","",RANK(F26,$D26:$M26,1))

This formula is in cell F27 of a sheet which has a series of totals in
D26 to M26, some of which may be blank - the formula checks if the cell
above is blank and only returns the RANK order if the total cell is not
blank. The formula is copied across from D27 to M27.

Hope this helps.

Pete

Pillar wrote:
I need to rank a column but ignore some cells which do not meets a criteria
of having another columns cell filled by data.