Hello everyone,
I have a pivot table and I want to sort numerical data. The numbers I have for example are;
10
100
1000
12
130
150
18
I want these to be sorted into lowest to highest;
10
12
18
100
130
150
1000
Is there anyway I can do this apart from dragging them all manually?
Thanks
Suspect when you do the Pivot table, your "number" is no number type, is TEXT.
Suggest change the format to number, and do your pivot. It will auto sort.
Is it better can look the file you mention.
Last edited by wenqq3; 04-25-2013 at 03:08 AM.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thank you, it was just a case of formatting, I haven't quite woke up this morning!
Welcome,it great it help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks