Register
Log In
Unanswered
Home
New Member
May 9, 2017
Offline
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
July 16, 2010
Offline
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
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
