LinkBack URL
About LinkBacks
Hello
I attached I have a sample of a data set sorted with vlookup
What im wanting to do is find the value from previous cell but only when the two yes values occur
Hope this is clear
Thank You
Hello
I attached I have a sample of a data set sorted with vlookup
What im wanting to do is find the value from previous cell but only when the two yes values occur
Hope this is clear
Thank You
Remoive ALL expected results, then this in M3 and copy down:
=IF(AND(J3="YES",K3="YES"),HSTACK(F3-F2,G3-G2),"")
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
im getting #NAME?
You shouldn't - your profile says Excel 365. Is it fully up-to-date? Or is your profile wrong?
If you don't have 365, then please change your profile. You'd then need two separate formulae copied down:
=IF(AND(J3="YES",K3="YES"),F3-F2,"")
=IF(AND(J3="YES",K3="YES"),G3-G2,"")
PS HSTACK was introduced in March 2022, so if your 365 predates that, you need to run an update.
Last edited by AliGW; 08-27-2024 at 04:46 AM.
Thanks for the rep. Your foruum profile has not been updated - if you are not using 365, then it needs doing, please.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks