Hi,
I am attempting to do something simple, which is return all the instances of some data that meets one criteria. For some reason, the formula i've concocted is not wanting to cooperate.
As always, attached is an example.
What I am looking for is to return the "ENTRY ID" for all entries that are associated with "TYPE" as "S8".
My attempt is located in the sample with manually calculated results.
Thanks for the help.
Try this:
=IFERROR(IF(ROWS($E$19:E19)>$E$14,"",INDEX(E:E,SMALL(IF($F$19:$F$30="S8",ROW($E$19:$E$30)),ROWS($A$1:A1)))),"")
array entered.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Or using the AGGREGATE function (mimicking SMALL) to avoid array-entry:
Please Login or Register to view this content.
Last edited by leelnich; 12-30-2017 at 05:25 AM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
or... again a non-array version, copied across and down:
=IFERROR(INDEX(E:E,SMALL(INDEX(($F$19:$F$30<>"S8")*10^10+ROW($F$19:$F$30),0),ROWS(I$18:I18))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hello,
All work great! Thank you
You're welcome.
Glad to have helped - thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks