I am sorting a selection of data that has been brough into my sheet via vlookups that are percentages. I am after putting together a leaderboard and have noticed that my sort, whether it be via a macro or by manually selecting the sort tool, puts 100% below lower percentages.
Please can I get some help on this as its really holding up my day and potentially making me bold from pulling my hair out!!!
It sounds as though the values being sorted are stored as text rather true numbers - can you post a sample ?
EDIT: disregard that - are the values you're trying to sort formulae ?
Last edited by DonkeyOte; 04-06-2010 at 08:18 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Yeah its coming from another sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks