Cannot use advanced sorting after .cvs import

strat919

Board Regular
Joined
May 15, 2019
Messages
54
I have tried over an hour and cannot figure out why it won't sort correctly. I have imported a .cvs file and delimited.

I am trying to sort with 2 levels on 2 columns. It sorts fine when I only sort 1 level. When I sort with 2 levels, the 1st level sorts correctly, but the second level I create does nothing.

I did a test with a fresh spreadsheet just entering random values and the 2 level sorting worked correctly.

It doesn't like my .cvs imports for some reason.

One of the columns I have is numbers and letters, but I tested by changing to all numbers and that didn't make any difference.

Any help would be appreciated:)

David
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,339
Office Version
2019, 2016, 2013
Platform
Windows
did you save into native excel format after import
 

Watch MrExcel Video

Forum statistics

Threads
1,099,362
Messages
5,468,179
Members
406,569
Latest member
Quest_

This Week's Hot Topics

Top