+ Reply to Thread
Results 1 to 8 of 8

Extracting data from column that fits criteria

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    Troy, MI
    MS-Off Ver
    Excel 2007
    Posts
    12

    Extracting data from column that fits criteria

    Hello All,

    Excel newbie here and have a question in regards to data extraction without using the built in autofilter from excel. I should also mention that I am using Excel 2007.

    Given a column A of data, I want to make a new column B with the data from A that meet a certain criteria. It sounds pretty simple yet it makes me want to kick my computer since I cannot figure it out. Here is what I have written and I receive a #NUM! error:
    A is the column of data, B is the extracted Data, A12 is the Count of how many met criteria. C2 is the Criteria Value.

    HTML Code: 

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Extracting data from column that fits criteria

    Hi,

    What are the values (and formats) of the entries in A2:A10 and C2?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    10-18-2013
    Location
    Troy, MI
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Extracting data from column that fits criteria

    Just numeric values. I was trying to be somewhat broad because the sheet I am making is rather extensive but I can attach if needed.

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Extracting data from column that fits criteria

    Well, I can see nothing syntactically wrong with your formula, and if you're happy with the format of the data concerned and you've verified that there is at least one result which matches the formula criteria, then yes, I think you'll need to attach a sample in order to investigate further.

    Regards

  5. #5
    Registered User
    Join Date
    10-18-2013
    Location
    Troy, MI
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Extracting data from column that fits criteria

    Sample.xlsx


    The above is a sample of what I have been attempting to do. I have the raw data and criteria and want to produce the raw data that met criteria onto the filtered tab.

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Extracting data from column that fits criteria

    Ok, well for a start this criterion in your formula:

    ...IF(Raw_Data!$F$4:Raw_Data!$F$254<Criteria!$C$7...

    is never currently satisfied, since Criteria!$C$7=2700 and the minimum value in Raw_Data!$F$4:Raw_Data!$F$254 (not sure why you have it like this syntactically - nothing wrong with it, though Raw_Data!$F$4:$F$254 will suffice) is 2743.67582449844.

    Regards
    Last edited by XOR LX; 10-29-2013 at 11:30 AM.

  7. #7
    Registered User
    Join Date
    10-18-2013
    Location
    Troy, MI
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Extracting data from column that fits criteria

    I was using the wrong cell for criteria.... -_-. You are right, once I fix that cell number it works perfectly. Wow I feel like an idiot.
    Thank you so much XOR LX

  8. #8
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Extracting data from column that fits criteria

    Hey, don't worry about it! It's often the simple things that trip us!

    And you're welcome.

+ 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. Extracting data from column based on specific criteria and pasting into new column
    By vanvalkenburg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2012, 10:26 PM
  2. Move row data from one sheet that fits certain criteria to another sheet
    By sstewar1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2011, 06:16 PM
  3. Replies: 6
    Last Post: 04-16-2011, 07:38 AM
  4. Help - Extracting an entire row that fits a single criteria
    By Babyanne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2009, 06:40 PM
  5. Look up that fits 2 criteria
    By njexpress9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2009, 04:53 PM

Tags for this Thread

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