I looked over the correspondence using INDEX, SMALL and ROW. I can't get it
to work. This is my formula (right out of the help pages on this subject:
=INDEX($A$1:$B$7,SMALL9if($A$1:$A$7=$A$10,ROW($A$1 :$A$7)),ROW(1:1))
I have my Columns A1-A7 set up with names. I have my columns B1-B7 set up
with whole numbers. I set my cell A10 with a name that is in the A column
twice. All I get back is #VALUE.
I decreased the formula to
=SMALL(IF$A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)) and got the same thing.
It asks that I use CTRL+SHIFT+ENTER. I dont' see anything happening.
When I track the forumla it is returning the correct row numbers; but it
will not display in the cell.