Excel - cannot sort large-to-small

DaddyTorgo · 09-21-2012, 01:43 PM

I have a spreadsheet I'm trying to sort. The first time I did it, it worked fine...I sorted by column a (text) and then by column b (numbers).

I opened a new instance of excel and created a test sheet and i can sort largest to smallest again, but if I go back and re-export the data for the first sheet I still can't.

I literally have them open side-by-side and I can't sort the data i exported out of salesforce. which is weird, as i've always been able to in the past...

WTF

Rizon · 09-21-2012, 01:48 PM

Maybe it's not recognizing it as numbers? Check cell formatting?

Coffee Warlord · 09-21-2012, 01:50 PM

S'what I was thinking. Maybe you need to reset that columns to a numeric type or something.

DaddyTorgo · 09-21-2012, 01:51 PM

Already tried that - first thing I thought of too. It's not that.

And in the second instance of excel i have open it sorted it perfectly fine - first column numbers, second column text. And both options were there in the sort dropdowns.

Even when I select just that one column it won't give me the option to sort largest-to-smallest.

Fucking Excel.

DaddyTorgo · 09-21-2012, 02:09 PM

Weird...I just exported one report from Salesforce to excel in regular format (not "printable view" format which my partner prefers) and made sure that its column was in numbers and could sort it largest-to-smallest fine, but when I export in "printable view" I can't sort largest-to-smallest even after making sure the column is in number format, and selecting only the values that are there (not the header line).

Aaaah - figured it out. Apparently it's picking up the "-" that Salesforce populates for an empty field and that's kicking it back from thinking it's a number.

WOOHOO...NOT CRAZY. PROBLEM-SOLVER!

Suburban Rhythm · 09-21-2012, 02:10 PM

Where are you sorting from?

There is the 'Sort & Filter' button to the far right of the home tab. That's crap, don't use it. I've seen goofy issues with that before.

Choose Sort under the Data tab

Also, when you say you are exporting from salesforce, any possibility it is creating a table with the data, rather than just plotting into the sheet?

DaddyTorgo · 09-21-2012, 02:12 PM

Funny - i don't feel like it's ever picked up the " - " before this and kicked it back. wicked weird.

CU Tiger · 09-21-2012, 02:14 PM

the newest edition of excel has thrown me a few curves lately as well.
It appears to have some under the hood formatting functions we cant see/edit. I cant think of an exact example, but Ive see the exact ssame behavior you are describing.

M GO BLUE!!! · 09-21-2012, 04:32 PM

Did you create a spreadsheet of the women that you are writing to online & trying to sort by weight?

09-21-2012, 01:51 PM	#4
DaddyTorgo Hall Of Famer Join Date: Oct 2002 Location: Massachusetts	Already tried that - first thing I thought of too. It's not that. And in the second instance of excel i have open it sorted it perfectly fine - first column numbers, second column text. And both options were there in the sort dropdowns. Even when I select just that one column it won't give me the option to sort largest-to-smallest. Fucking Excel. Last edited by DaddyTorgo : 09-21-2012 at 01:56 PM.

09-21-2012, 02:09 PM	#5
DaddyTorgo Hall Of Famer Join Date: Oct 2002 Location: Massachusetts	Weird...I just exported one report from Salesforce to excel in regular format (not "printable view" format which my partner prefers) and made sure that its column was in numbers and could sort it largest-to-smallest fine, but when I export in "printable view" I can't sort largest-to-smallest even after making sure the column is in number format, and selecting only the values that are there (not the header line). Aaaah - figured it out. Apparently it's picking up the "-" that Salesforce populates for an empty field and that's kicking it back from thinking it's a number. WOOHOO...NOT CRAZY. PROBLEM-SOLVER! Last edited by DaddyTorgo : 09-21-2012 at 02:12 PM.

09-21-2012, 02:10 PM	#6
Suburban Rhythm Pro Starter Join Date: Jan 2002 Location: Pittsburgh	Where are you sorting from? There is the 'Sort & Filter' button to the far right of the home tab. That's crap, don't use it. I've seen goofy issues with that before. Choose Sort under the Data tab Also, when you say you are exporting from salesforce, any possibility it is creating a table with the data, rather than just plotting into the sheet? __________________ "Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!"

09-21-2012, 04:32 PM	#9
M GO BLUE!!! Pro Starter Join Date: Sep 2005	Did you create a spreadsheet of the women that you are writing to online & trying to sort by weight? Last edited by M GO BLUE!!! : 09-21-2012 at 04:32 PM.

09-21-2012, 01:50 PM	#3
Coffee Warlord Head Coach Join Date: Oct 2002 Location: Colorado Springs	S'what I was thinking. Maybe you need to reset that columns to a numeric type or something.

09-21-2012, 02:12 PM	#7
DaddyTorgo Hall Of Famer Join Date: Oct 2002 Location: Massachusetts	Funny - i don't feel like it's ever picked up the " - " before this and kicked it back. wicked weird.

09-21-2012, 02:14 PM	#8
CU Tiger Grizzled Veteran Join Date: Nov 2006 Location: Backwoods, SC	the newest edition of excel has thrown me a few curves lately as well. It appears to have some under the hood formatting functions we cant see/edit. I cant think of an exact example, but Ive see the exact ssame behavior you are describing.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)