If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sort by even and odd digits and copy to separate worksheet
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! |
#2
|
|||
|
|||
Sort by even and odd digits and copy to separate worksheet
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! |
#3
|
|||
|
|||
Sort by even and odd digits and copy to separate worksheet
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! |
#4
|
|||
|
|||
Sort by even and odd digits and copy to separate worksheet
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! |
Thread Tools | |
Display Modes | |
|
|