• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Data from column based on multiple criteria (dates, names,numbers,etc)

G

gonzo1717

New Member
First and foremost.... THANK YOU for all your help and knowledge on excel. If it wasn't for online communities such as Chandoo, I would have surely been stuck in a "rut" multiple times on work projects!

I am currently working on a project in which over the past couple weeks I have not been able to remedy. I would like to extract data from COL B to another row based on multiple search criteria including date ranges e.g. 01/01/16 - 09/29/17 in COL A , Name COL C the current COL D (which will need to include "completed" in one extraction, then omit "completed" in the next extraction), status COL E (one extraction for numbers, another for "empty", Duplicate Entry COL F (only need to extract values here with the value of 0) then whether or not there is a date in Date 1 then Date 2 then Date 3 then Date 4 COL G,H,I,J.

COL G H I J will require separate results as the dates are particular to what stage the review process is in.

The closest I have come to reaching my goal was this instruction here https://chandoo.org/wp/2011/11/18/formula-forensics-003/

but was not able to get it working.

I hope this makes sense! Thank you in advance for any help. It is greatly appreciated!
 

Attachments

  • Example.xlsx
    9.4 KB · Views: 10
Hui said:
Gonzo

Firstly, Welcome to the Chandoo.org Forums

Did you read the follow up to Formula Forensics 003 which deals with multiple criteria?
Click to expand...

Hello Hui! Thank you for the reply!

Yes, I read the follow up and tried applying it to my data. After several attempts at changing the formula around, I only was able to return a NAME error? Maybe I'm entering something in wrong?
 
Can you please post what you expect as a sample output for several lines of input data
 
Hello again Hui,

I apologize for the delay. I was out of town for the weekend. I have reworked the example and have provided a data output to the right of the data... What I usually do to find my output data is utilize filtering however, this is very time consuming as there are several thousand lines of data that I must extract COL B numbers from based on different COL C names.....

Thank you so much for your time!
 

Attachments

  • Example2.xlsx
    11.7 KB · Views: 8
You must log in or register to reply here.
Back
Top