As you’ll notice in attached sample “Workbook 8” I have a formula in B and D, which nicely to pull out all “odd” number and “even” numbers.
As you see the list A1:A80 there are what I would call “split” numbers - i.e. 12, 23, 52, etc. Numbers which one number is “odd” (1, 3, 5, 7, 9).
Is there a formula I could use to sort those numbers from my list in A an place in Column F?
Last edited by khank; 08-14-2012 at 12:00 PM.
So you want to look at the individual digits within the number and if they are a mixture of odd and even, put them in column F as opposed to B or D?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes that is what I'm looking to do...
Try this..
=IF(A1<10,"",IF(OR(AND(MOD(INT(A1/10),2)=0,MOD(A1,2)<>0),AND(MOD(INT(A1/10),2)<>0,MOD(A1,2)=0)),A1,""))
Life's a spreadsheet, Excel!
Say thanks, Click *
How about
=IF(AND(A1>10,MOD(LEFT(A1,1)+RIGHT(A1,1),2)),A1,"")
Thank you - both formula's work well...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks