This is a second function to a prior question wherein we removed an alpha
character from the end of a number down the full length of a column. Now
they want me to sort these data into even and odd numbers and copy them and
their correspondending data to another worksheet.

Is there a way to add these two functions to the following formula?

=LEFT(A1,LEN(A1)-1)+0


You all are wonderful... I've been away from Excel for years and have
forgotton even the basics of writing forumlas and macros. Back to the books !

Thanks so much!

Hi again

Put this on the sheet where you want the even numbers and drag down.
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=0,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

and for the odd numbers
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=1,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

In both case mind the line wrap it's a single line. you will get gaps but
these will dissappear when you sort the data.

Mike


"K Drier" wrote:

This is a second function to a prior question wherein we removed an alpha
character from the end of a number down the full length of a column. Now
they want me to sort these data into even and odd numbers and copy them and
their correspondending data to another worksheet.

Is there a way to add these two functions to the following formula?

=LEFT(A1,LEN(A1)-1)+0


You all are wonderful... I've been away from Excel for years and have
forgotton even the basics of writing forumlas and macros. Back to the books !

Thanks so much!

Mike... something isn't working here. I entered this into the spreadsheet and
it keeps giving me an error about using - and = signs in the formula needing
a ' preceeding them. Do I need to delete the previous formula which removed
the alpha character from the end and just use this one instead?

Thanks for your help... I am trying to remember all these things...

"Mike H" wrote:

Hi again

Put this on the sheet where you want the even numbers and drag down.
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=0,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

and for the odd numbers
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=1,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

In both case mind the line wrap it's a single line. you will get gaps but
these will dissappear when you sort the data.

Mike


"K Drier" wrote:

This is a second function to a prior question wherein we removed an alpha
character from the end of a number down the full length of a column. Now
they want me to sort these data into even and odd numbers and copy them and
their correspondending data to another worksheet.

Is there a way to add these two functions to the following formula?

=LEFT(A1,LEN(A1)-1)+0


You all are wonderful... I've been away from Excel for years and have
forgotton even the basics of writing forumlas and macros. Back to the books !

Thanks so much!

Well, I've tried this several times and can't get it to work, it keeps giving
me a "Value" error. I can't seem to find where the error is originating
from, can anyone help?

"Mike H" wrote:

Hi again

Put this on the sheet where you want the even numbers and drag down.
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=0,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

and for the odd numbers
=IF(MOD(LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,2)=1,LEFT(Sheet1!A1,LEN(Sheet1!A1)-1)+0,"")

In both case mind the line wrap it's a single line. you will get gaps but
these will dissappear when you sort the data.

Mike


"K Drier" wrote:

This is a second function to a prior question wherein we removed an alpha
character from the end of a number down the full length of a column. Now
they want me to sort these data into even and odd numbers and copy them and
their correspondending data to another worksheet.

Is there a way to add these two functions to the following formula?

=LEFT(A1,LEN(A1)-1)+0


You all are wonderful... I've been away from Excel for years and have
forgotton even the basics of writing forumlas and macros. Back to the books !

Thanks so much!