Please paste this function in the cell i6
Array:
=INDEX($C$5:$C$9,SMALL(IF($D$5:$D$9=$I$2,IF($E$5:$E$9=$I$3,ROW($C$5:$C$9)-ROW($C$5)+1)),1))
Non-Array (Ctrl+Shift+Enter is not required)
=INDEX($C$5:$C$9,MATCH(LARGE(INDEX(($D$5:$D$9=$I$2)*($E$5:$E$9=$I$3)*(1/ROW($D$5:$D$9)),0),1),INDEX(($D$5:$D$9=$I$2)*($E$5:$E$9=$I$3)*(1/ROW($D$5:$D$9)),0),0))
Please click 'Add reputation', if my answer helped you.
Hi
ramananhrm, thank you for working that out for me :-)
it works perfectly for the first row, but then when I copy the formula down to find the next one with that criteria it doesnt find it and just returns the first one again.
sorry to be a pain
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks