"Will" wrote
Max, Its work..

Yes, of course it does <g
I tested it before posting.

If i have 100 over cells in the table,
meaning i have to do the CF one by one?

No, no .. you can do it all at one go by selecting the range (with the
active cell at the top left corner of the selected range), then apply the CF
formula which references that top left corner's active cell

If you re-read my 1st response, the step given was
Select A1:E6 (A1 active) ..

Example:

If your 100 cells range to be CF'd is say, B2:F21,

Select B2:F21 (with B2 active),
then apply the CF using the formula:
=MATCH(B2,LARGE($B$2:$F$21,COLUMN($A:$C)),0)

Note that the CF formula references the active cell (B2) in the selected
range. The active cell is the cell you click on to start selecting the
range. It'll appear as "white" within the selected range.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---