View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sandeep Jangra[_2_] Sandeep Jangra[_2_] is offline
external usenet poster
 
Posts: 17
Default Help on {=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 ))}

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