Display data by searching in multiple sheet

[abraham30]

Hello Everyone!

In my attached spreadsheet, I want to display data like in sheet "Template"
i.e. Data should be populated automatically in column B, C, J, K, L by searching data in respective created date sheet. (if not found, put zero in all columns)



-->Please note that multiple sheet (ie. 01-Dec-2013, 02-Dec-2013) contain data of different date in column "Download_DT".

that means if you check work sheet (01-Dec-2013), the "Download_DT" column contain date like 01/12/2013 20:34
27/11/2013 20:34
28/11/2013 20:34

So, formula will choose only data of correct date (i.e. 01/12/2013 20:34).


Due to space constraint, I am not able to create multiple sheet with respective date.

Advance thanks for your help

[hemesh]

Hello And Welcome to forum abhraham ! yes you can do that

try this formula in template in B2 =SUMPRODUCT(--(INDIRECT("'"&TEXT($A2,"DD-mmm-yyyy")&"'!"&"$E$2:$E$1000")=B$1)*(INDIRECT("'"&TEXT($A2,"DD-mmm-yyyy")&"'!"&"$D$2:$D$1000")=$A2)) and enter then drag down and drag to right but you need to keep the same date&Time in A2,A3 and so on as in your month
sheet(copy and paste the date from your month sheet to A2

[hemesh]

Hello fnd attached!

Hope this helps

[abraham30]

Thanks for your help.

For columns J, K and L, how to display the check with highest number of records in descending order.
How to proceed

[abraham30]

I got solution for part of my query through Hemesh .

Can anybody help me how to display top three name with highest record.

Newly Attached sheet for your reference (output should be in template sheet)

Advance thanks

[Tony Valko]

Can anybody help me how to display top three name with highest record.

Newly Attached sheet for your reference (output should be in template sheet)

Since this is a different question you should start a new thread.

Makes things easier to find when you do a search if the thread is kept to a single topic.