Hey Guys,
I need to find the first row in a table that matches a value when two criteria are met. I've attached a super simple spreadsheet, probably a very easy formula for you guys but a bit tricky for me!
Thanks in advance.
Matt
Hey Guys,
I need to find the first row in a table that matches a value when two criteria are met. I've attached a super simple spreadsheet, probably a very easy formula for you guys but a bit tricky for me!
Thanks in advance.
Matt
Last edited by mattzkn; 03-01-2020 at 09:16 AM. Reason: typo
Are you still using Excel 2007? If not, please update your user profile. Thanks.
Your expected results are not all correct:
=MIN(IF($B$2:$B$13=G2,IF($C$2:$C$13>0,$D$2:$D$13)))
... entered using CTRL+SHIFT+ENTER (not just ENTER).
Last edited by AliGW; 03-01-2020 at 09:32 AM.
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
=MIN(IF(($B$2:$B$13=G2)*($C$2:$C$13>0),$D$2:$D$13))
Close te formula with CSE
That works perfectly!
Unfortunately i've realised there is one more criteria to be met. I've added this in a new column and tried stacking another IF into your equation but couldn't get it to work.
I've attached the updated spreadsheet, could you take a look and see if you can get it to work with one more criteria (type must be "buy")
Either this:
=MIN(IF($B$2:$B$13=H2,IF($C$2:$C$13="buy",IF($D$2:$D$13>0,$E$2:$E$13))))
or this:
=MIN(IF(($B$2:$B$13=H2)*($C$2:$C$13="buy")*($D$2:$D$13>0),$E$2:$E$13))
Great, thanks
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks