Extract Data

[Abhijeet]

How to identify Overlap the Dates in next Data set

 

[Marc L]

Hi !

See advanced filter …

​

 

[Abhijeet]

I am using formula for Overlap between 2 dates any data. In attach file Data Set1 look in data Set 2. i want to use which data actually falls between can u please help me

 

[Marc L]

Far from initial post ‼ And unclear …

To extract data with several criterias, advanced filter is the easy way !
See the tutorials all over the web and search in this forum threads
« AdvancedFilter » to see concrete samples …
​

 

[Abhijeet]

i know advanced filter can extract the data but my problem Find Overlap the dates if any then that data i want to extract can u please show me how to do this in advanced filter

 

[Marc L]

I don't understand your criteria. But with reading tutorials,
seeing samples (many !) in this forum threads, with logic you'll succeed …

​

 

[Abhijeet]

Can u pls see my last attach file i am using this formula =SUMPRODUCT((G3<=$C$3:$C$100)*(H3>=$B$3:$B$100)*(F3=$A$3:$A$100)) to identify Overlap dates any

You told me use advanced filter so i ask u how to apply in this case please tell me

 

[Marc L]

From initial attachment Book1.xls, crystal clear explain criteria …


​

 

[Abhijeet]

Yes i just upload for understand but i want to use in my this workbook Sumproduct.xlsx data

I am trying to pull which Dates are Overlap that data i want to pull so please look my this attachment Sumproduct.xlsx & plesae help me

 

[Marc L]

I would help with a crystal clear explanation as you can't as always …

There are many AdvancedFilter samples in this forum threads.
And tutorials over the Net …
​

 

[Marc L]

From original attachment,
another way is to use filters on each criteria column, easy too …

​

 

[Abhijeet]

Mark L

can u please tell me in this file how to pull overlap data i use this formula =SUMPRODUCT((G3<=$C$3:$C$100)*(H3>=$B$3:$B$100)*(F3=$A$3:$A$100))

 

[Marc L]

As I yet wrote, without explaining any criteria, just follow tutorial
for calculated criteria and see samples in forums (at least here) …

Or instead of using formula you can use filters, that's easy !
Working with your initial attachment and as we often explained
in your past threads ! At beginner level …
​

 

[Marc L]

For those who read this thread, initial attachment was changed …


​