Hi, can anyone help with the following problem. I'm trying to find out
the position of the contents of a cell within a column. I know that the
value in cell B103 appears 4 times in column B from a COUNTIF function;
however, I need to know if the value in B103 is the first, second,
third or fourth time this value has appeared. Is there an easy way to
do this using formula? I need to set a calculation and the number of
OFFSETs required will depend on whther the value in B103 is the 1st,
2nd etc. Any help would be appreciated. Thanks. Alasdair.