ecxel sort

  • Thread starter Thread starter derek
  • Start date Start date
D

derek

Ch EC Tr Pad Leak CRes VXErr
25 GND GND 1 3 -0.9814
25 GND GND 10 3 -0.0977
70 251 C1 100 1 -2.1203
99 247 A2 101 1 -1.7079
69 60 D3 102 1 0.8122

can not sort entire page by pad order e.g.
1,2,3,4,5,6,7,8,9,10,11,12 etc jumps and sort by first
number e.g. 1,10,100 etc..need all 7 columns to sort by
one e.g. pad order
 
Hi derek,
Ch EC Tr Pad Leak CRes VXErr
25 GND GND 1 3 -0.9814
25 GND GND 10 3 -0.0977
70 251 C1 100 1 -2.1203
99 247 A2 101 1 -1.7079
69 60 D3 102 1 0.8122

can not sort entire page by pad order e.g.
1,2,3,4,5,6,7,8,9,10,11,12 etc jumps and sort by first
number e.g. 1,10,100 etc..need all 7 columns to sort by
one e.g. pad order
Click to expand...

The problem is that your Pad data is text instead of
numeric. To change it all to numeric data select the whole
PAD column then use Data-Text to Columns...
Choose delimited then click Next,
Uncheck all delimiters then click Next,
Set the Column data Format as General and click Finish.

Now when you sort by Pad the order will be 1,2,101,201

Repeat the above steps, but set the Column data format as
Text. Then the sort order is 1,101,2,201
 
Back
Top