I am trying to do a formula that ranks a list of numbers however ranking whilst ignoring + or - signs in that list, just using the number itself. Is this possible?
please find attached table that i am working on.
Any help would be highly appreciated.
Try incorporating =ABS()
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
hi thank you. I thought of that but i need the + / - sign back in later columns? Can't get my head around it yet.
Are we allowed a helper column?
Yes i don't see why not, it can be hidden.. What are your thoughts?
Thanks again for your interest
Have a look:
Perfect. Thank you ever so much. It was really confusing me. Thanks again.
You are most welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks