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

You could use an adjacent column with a formula like:

=mod(a1,2)
(and drag down all the rows)

Then sort your data by this column

Templar wrote:

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

--

Dave Peterson

In , Templar
spake thusly:

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.

When you say "group together," do you mean create temp columns
with just the relevant sets? Or is data filtering okay?
If data filtering suffices, one way is to create a new
column with the formula,

=IF(MOD(A1,2),"ODD","EVEN")

Then click and hold on the fill-handle and drag down (or
copy the formula by other means down the new column).
Now turn on auto-filter (Data / Filter / Auto-Filter).
Go to the column you've created and filter on EVEN or ODD.

=========================
1211
1211
1214
1216
1218
1219
1220
1221
1221
[...]

--
dman

Sorry, but I'm getting nowhere with this formula. I create a blank column to
the right of the numbers column.

Sorry if my question was confusing. I'll settle for putting all the entries
ending in an odd number in one column and all the entries ending in an even
number in a separate column. HOWEVER, what would really be desired is if I
could GROUP the entries ending in an even/odd number in sequence
1200
1202
1204
1206
1208
1210 and so forth, and then
1201
1203
1205
1207
1209
1211 and so forth
--
Templar


"Dallman Ross" wrote:

In , Templar
spake thusly:

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.

When you say "group together," do you mean create temp columns
with just the relevant sets? Or is data filtering okay?
If data filtering suffices, one way is to create a new
column with the formula,

=IF(MOD(A1,2),"ODD","EVEN")

Then click and hold on the fill-handle and drag down (or
copy the formula by other means down the new column).
Now turn on auto-filter (Data / Filter / Auto-Filter).
Go to the column you've created and filter on EVEN or ODD.

=========================
1211
1211
1214
1216
1218
1219
1220
1221
1221
[...]

--
dman