Search between date specified dates

[aamirsq]

Helloo,

I have a big data and its growing, what i was trying to do was search only between specified dates.
But couldn't .


Sample attached.

 

[Somendra Misra]

Hi,

What you are searching I could not found, All I can see that you extracted data on sheet2 from the date mentioned in A1 to the date mentioned in B1, for all the ID. Is this you want? you will enter the start date and end date and you should get all the data for all the id's?

Regards,

 

[Khalid NGO]

Hi aamirsq,

See if it helps...?

 

[aamirsq]

i tried it on my google spreadsheet & #n/a err.

=HLOOKUP($B$1,Main!$D$1:$Y$100,ROW()-1,FALSE)

 

[Khalid NGO]

Aamir,

Keep the following 2 in mind then try again:

Formula in C and E are same you can drag the formula of C to D.

And formula in D having little difference of A$1+1 for get date one day ahead.

Regards,

 

[Somendra Misra]

@aamirsq

See the file. Yellow cells has formula.

Regards,

 

[aamirsq]

My spread sheet link
https://docs.google.com/spreadsheets/d/1MStHRnh6GWJ-3fbkaOESeK_qCBQJnlE3xELEI2k2Xe8/edit?usp=sharing

 

[Khalid NGO]

Aamir,
Have you seen post # 5
and SM's (dynamic ans) post # 6 ?

 

[Somendra Misra]

@aamirsq

Well I cannot help you on Google Sheet, but see the attached file made on excel 2010. Please note the first three columns on sheet2 are entered manually. DO you want them to extract to?


Regards,

 

[aamirsq]

thanks for guys, i came up with below formula;

=IFERROR(HLOOKUP(E$3,Sheet1!$A$1:$AA$200,ROW()-2,FALSE),"")

& if anyone interested how i did it on my spreadsheet below is the link.
https://docs.google.com/spreadsheet...ESeK_qCBQJnlE3xELEI2k2Xe8/edit#gid=1700718679

If anyone have better solution . you are most welcome !!