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