I have attached file with and original and desired output. Please help me creating formula. 1st criteria is exact match and 2nd is greater nearest not lower nearest.
I have attached file with and original and desired output. Please help me creating formula. 1st criteria is exact match and 2nd is greater nearest not lower nearest.
Click * below if this answer helped
Duplicate thread closed. Continue in your other thread, where you need to exercise patience, please.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks