Hi

As an array formula, it is testing each cell in the range A1 to A7 to see if
it has the same value as that in cell A10
and returning what is the first row number that the value occurs in the
range.

--
Regards
Roger Govier

"Sandeep Jangra" wrote in message
...
Dear All,
Plz help on this formula
{=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 ))}, how this works as I
m
new excel user. what does is meant $A$1:$A$7=$A$10