trouble with sorting by 'x' then 'z'

joeloveszoe

Board Regular
Joined
Apr 24, 2014
Messages
51
hi
my data loos like this

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>
sku
status
productname
siteprice
listprice
sitecost
minimumqty
ACC72010-BULK
TRUE
Acco Binder Clip
0.47
1.88
0.36
360
ACC72020-BULK
TRUE
Acco Binder Clip
0.47
1.88
0.36
288
MEA63352-BULK
TRUE
Mead Plain Index Card
0.46
1.39
0.37
2736
MEA45354-BULK
TRUE
Mead Coil Memo Notebook
0.55
1.49
0.44
2304
MEA45464-BULK
TRUE
Mead Coil Memo Notebook
0.55
1.49
0.44
2304
MEA45534-BULK
TRUE
Mead Wire Binding Coil Memo Notebooks
0.55
1.49
0.44
2304
MEA45644-BULK
TRUE
Mead Open Side Memo Notebook
0.55
1.49
0.44
2304
WLJ54309-BULK
TRUE
Wilson Jones Insertable Tab Indexes
0.63
1.53
0.48
216
WLJ54310-BULK
TRUE
Wilson Jones Insertable Tab Indexes
0.63
1.53
0.48
216
MEA33100-BULK
TRUE
Mead 3-hole Punched Portfolio
0.64
1.39
0.51
1968

<tbody>
</tbody>

i am trying to sort by sku then sitecost - but it will not let me
any suggestions why it will only set by my 1st level?

thanks very much!
=) joe
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,511
Office Version
365
Platform
Windows
You should be able to do that pretty easily.
It looks like you have the sort order reversed, where you have it sorting by sitecost first, then SKU.
Make sure the SKU field is the first sort priority.
 

NewTricks

New Member
Joined
May 20, 2018
Messages
3
In the data presented, every entry in sku is unique, therefore a secondary sort is moot. If this is only a sample of the data, look down the sku field to find duplicates; only there will a secondary sort change the order.
 

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top