Thread: [Solved] Function problem
View Single Post
 
Old 02-17-2012, 05:21 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Your formula is this:

=IFERROR(INDEX($B$19:$B$25,SMALL(IF($A$19:$A$25= $G$18,ROW($19:$25) -1,""),ROW() -1)),"")

It should be this:

=IFERROR(INDEX($B$19:$B$25,SMALL(IF($A$19:$A$25= $G$18,ROW($A$19:$A$25) -ROW($A$19)+1),ROW() -ROW($G$19)+1)),"")


So

ROW($A$19:$A$25)-ROW($A$19)+1 gives you {1;2;3;4;5;6;7}

and
,ROW()-ROW($G$19)+1 will give you {1} when the formula is on row 19, {2} when the formula is on row 20, etc
Reply With Quote