Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
890
Views
Topic starter
i change this formula =IF(ISERROR(INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(1:1)),2)),INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8=$E$1,ROW($A$1:$A$8)),ROW(1:1)),2),2) so it returns values that don't match E1 instead of those that do
Posted : 10/05/2017 8:49 am
You could try:
=IF(ISERROR(INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8<>$E$1,ROW($A$1:$A$8)),ROW(1:1)),2)),INDEX($A$1:$B$8, SMALL(IF($A$1:$A$8<>$E$1,ROW($A$1:$A$8)),ROW(1:1)),2),2)
If that doesn't work, then please provide a sample Excel file so we can see your formula in context and understand what you're trying to achieve.
Also, in future please keep the topic title brief so it's easy to read.
Thanks,
Mynda
Posted : 14/05/2017 7:02 am