Hi,
I am able to pull a closest match using the index and match formula. However, the results duplicate if my amounts are the same. Is there a way to edit the formula so that it pulls the 1st closest match then for any duplicate amounts the 2nd,3rd etc...???
My current formula is in col D and my desired outcome in col E. Any help would be greatly appreciated!
Thanks
like this___________
Looks Perfect! THANK YOU!
Perhaps this array entered:Formula:
=IFERROR(IF($C3>MIN($K$3:$K$12),SMALL(IFERROR(IF(($K$3:$K$12>MIN($K$3:$K$12)),$L$3:$L$12,""),""),ROWS($1:1))),"no match")
Edit: Oops. Late post.
Last edited by FlameRetired; 12-16-2014 at 02:46 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks