+ Reply to Thread
Results 1 to 2 of 2

Need help making a new column that contains only the numbers from another column.

  1. #1
    Registered User
    Join Date
    05-03-2014
    Location
    Los angeles, CA
    MS-Off Ver
    Office 365 Mac
    Posts
    1

    Need help making a new column that contains only the numbers from another column.

    I have a column of values I need to analyze. There are about 90,000 cells. Most of them are FALSE but some of them are numbers.

    It looks something like this.

    FALSE
    FALSE
    FALSE
    FALSE
    0.12
    FALSE
    FALSE
    FALSE
    0.182
    FALSE
    FALSE
    FALSE
    FALSE
    FALSE
    FALSE
    0.233
    FALSE
    FALSE
    0.300
    ...

    I need to perform simple operations on the numerical values. (for example, 0.182 - 0.12 and then 0.3 - 0.233). I'm not sure how to scan the column for a number and then subtract it from the next number that shows up, so I figured it would be easier if I could reorganize the column to get rid of all the FALSE cells. So I want it to end up just looking like:

    0.12
    0.182
    0.233
    0.300
    ...

    Can anyone help me to figure out how to accomplish this? Or perhaps another suggestion on how I can perform my desired operations without reorganizing the column?

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Need help making a new column that contains only the numbers from another column.

    If you want to get the listed numeric values in other column, try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter.

    Assuming your values are in col. A in the range A2:A20, then try this array formula in B2 or any cell of your choice where you want to list numeric values....

    Please Login or Register  to view this content.
    and then confirm with Ctrl+Shift+Enter and drag down until you get the blank cells.

    If you want to have numeric values in the original column itself after deleting the non-numeric values, you will need a VBA solution to achieve that.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)
    By it_electronics2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2012, 08:56 AM
  2. [SOLVED] Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)
    By it_electronics2000 in forum Excel General
    Replies: 5
    Last Post: 04-06-2012, 12:02 PM
  3. [SOLVED] Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)
    By it_electronics2000 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2012, 11:18 AM
  4. [SOLVED] Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)
    By it_electronics2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2012, 11:13 AM
  5. [SOLVED] Making a column of numbers created from a formula permanent.
    By jba919 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2006, 02:30 PM

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