LinkBack URL
About LinkBacks
Hi, My Match Function is not working.. Can anyone see what I am doing wrong.
I need it to return the next Highest value so I am using the Match type of "-1" but I am getting a "#N/A" Error.. I should be getting a returned value of "10"
Hi, My Match Function is not working.. Can anyone see what I am doing wrong.
I need it to return the next Highest value so I am using the Match type of "-1" but I am getting a "#N/A" Error.. I should be getting a returned value of "10"
Your array should be sorted in descending order, when using the -1 match type.
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
With those microscopic characters, I surely can't. Attaching a sheet instead of a picture makes it easier to work with.Can anyone see what I am doing wrong.
Have resorted by descending order and have attached the sheet.
You sorted the wrong thing... The bits in green are what you should have changed.
Yes just realized my mistake just before you sent..
Got it to work in my Dummy sheet so am just putting into my proper one now. Will let you know how I go..
THANKS!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks