To max and min comparing with two sheets:

Hi.

I have attached three excel sheets are Data 1,Data 2 and Required Format.

Querry-01.

To compare two excel sheets to return max and min number.

DATA 1

CUSTOMERID* DISPATCH *****DATE BATCH NO
31 ********02/01/2016 **********11814
31 ********02/01/2016 **********11814
31 ********02/01/2016 **********11814
31 ********02/01/2016 **********11814
31 ********02/01/2016 **********11814
31 ********02/01/2016 **********11808
31 ********02/01/2016 **********11808
31 ********02/01/2016 **********11808



DATA 2

CUSTOMER ID ****DISPATCH ********DATE BATCH NO
42 *************08/01/2016 ********11884
42 *************08/01/2016 ********11884
42 *************08/01/2016 ********11884
42 *************08/01/2016 ********11884
35 *************08/01/2016 ********11892
35 *************08/01/2016 ********11892
35 *************08/01/2016 ********11892
35 *************08/01/2016 ********11892
35 *************08/01/2016 ********11892


REQUIRED FORMAT:

STARTING BATCH NO:11808

END BATCH NO:11892

Querry-02.

To end of date how many records passed on single day comparing with two sheets.

REQUIRED FORMAT:

DATE************NO OF RECORDS

02/01/2016*************8

04/01/2016*************19

Herewith attached file.Please help me.