LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default sorting data in a column

One of the columns (of ten columns) in my spreadsheet looks like the one
copied below except that it is 40 pages long. I would like to group together
all the numbers ending in add numbers and even numbers separately. Could you
please explain to me how I can accomplish this? Thank you.
1211
1211
1214
1216
1218
1219
1220
1221
1221
1222
1225
1226
1228
1233
1235
1235
1236
1237
1240
1242
1243
1248
1306
1311
1312
1320
1321
1322
1323
1330
1330
1331
1334
1334
1336
1337
1340
1341
1343
1344
1344
1344
1347
1347
1348
1402



--
Templar
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
About sorting and extracting data in one column Ting Li Excel Worksheet Functions 7 June 9th 07 01:59 AM
sorting column data Matt T Excel Worksheet Functions 2 June 1st 07 02:34 PM
Help sorting data into own column skint Excel Discussion (Misc queries) 1 April 7th 06 10:18 PM
Sorting Data in a column BigAndy Excel Discussion (Misc queries) 1 September 13th 05 10:05 AM
Sorting data in a table by the header of a column? Aaron Excel Discussion (Misc queries) 2 May 27th 05 02:01 PM


All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"