Results 1 to 6 of 6

Finding "split" numbers from a list

Threaded View

khank Finding "split" numbers from... 08-14-2012, 11:34 AM
ChemistB Re: Finding "split" numbers... 08-14-2012, 11:41 AM
khank Re: Finding "split" numbers... 08-14-2012, 11:45 AM
Ace_XL Re: Finding "split" numbers... 08-14-2012, 11:43 AM
jindon Re: Finding "split" numbers... 08-14-2012, 11:45 AM
khank Re: Finding "split" numbers... 08-14-2012, 12:00 PM
  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Finding "split" numbers from a list

    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?
    Attached Files Attached Files
    Last edited by khank; 08-14-2012 at 12:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1