Spreadsheet: 600668d1543902642-how-to-extract-data-from-a-large-list-via-date-one-day-summary-ms-excel-problem-data-extraction-from-last-list-ans
Sheet: Mockup

 |  |  |  |  |  |  |  | Date | 2018-11-22 00:00:00 | Just Changing Date and below data should be extracted from Left mention list. As shown in below [NAME].
Sr No | Slip No | Amount | Amount  Collection | Remarks | Date |  |  |  |  | (it could be a large List 365days.)
1 | 1645 | 1500 | Fee &  Funds |  | 2018-11-22 00:00:00 |  |  | Fee &  Funds |  |  |  | For Syllabus
2 | 1658 | 13000 | Fee &  Funds |  | 2018-11-22 00:00:00 |  |  |  | Amount
3 | 1679 | 1500 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 1 | 1645 | 1500 | 1658 | 1000 | 7890 | 1500 | Canteen | 200
4 | 1820 | 1200 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 2 | 1658 | 13000 | 1679 | 800 | 7948 | 1500 | Fine | 90 |  | Categories
5 | 1904 | 1000 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 3 | 1679 | 1500 | 1820 | 1600 | 7952 | 170 | Fee Card | 150 |  |  | For Syllabus |  | Slip No & Amount extract from List for syllabus category
6 | 2001 | 800 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 4 | 1820 | 1200 | 1904 | 1700 | 7863 | 150 | [NAME] | 90 |  |  | Other |  | Other's text & Amount extract from List for Other category
7 | 3057 | 1600 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 5 | 1904 | 1000 | 2001 | 1400 | 7159 | 50 |  |  |  |  | Fee & Funds |  | Slip No & Amount extract from List for syllabus category
8 | 6904 | 1700 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 6 | 2001 | 800 | 3057 | 1300
9 | 1908 | 1400 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 7 | 3057 | 1600 | 1904 | 1500
10 | 2806 | 1300 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 8 | 6904 | 1700
11 | 1904 | 1500 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 9 | 1908 | 1400
12 | 1230 | 1100 | Fee &  Funds |  | 2018-11-22 00:00:00 |  | 10 | 2806 | 1300
13 | 7890 | 1500 | For Syllabus |  | 2018-11-22 00:00:00 |  | 11 | 1904 | 1500
14 | 7948 | 1500 | For Syllabus |  | 2018-11-22 00:00:00 |  | 12 | 2001 | 1100
15 | 7952 | 170 | For Syllabus |  | 2018-11-22 00:00:00 |  | 13 | 3057 | 1300
16 | 7863 | 150 | For Syllabus |  | 2018-11-22 00:00:00 |  | 14 | 6904 | 1500
17 | 7159 | 50 | For Syllabus |  | 2018-11-22 00:00:00 |  | 15 | 1908 | 1100
18 | 7814 | 1500 | For Syllabus |  | 2018-11-22 00:00:00 |  |  | Total |  |  |  | Total |  | Total
19 | 7819 | 1000 | For Syllabus |  | 2018-11-22 00:00:00
20 |  | 200 | Other | Canteen | 2018-11-22 00:00:00
21 |  | 90 | Other | Fine | 2018-11-22 00:00:00
22 |  | 150 | Other | Fee Card | 2018-11-22 00:00:00 |  |  | Please Add fuctions in sheet "Layout & Sample" For requested help. Thank You.
23 |  | 90 | Other | [NAME] | 2018-11-22 00:00:00 |  |  | I added a Picture with explanation in sheet "Problem Explained" for what I actually want. Please check if needed.
24 | 3057 | 1600 | Fee &  Funds |  | 2018-11-25 00:00:00
25 | 6904 | 1700 | Fee &  Funds |  | 2018-11-25 00:00:00
26 | 1908 | 1400 | Fee &  Funds |  | 2018-11-25 00:00:00
27 | 2806 | 1300 | Fee &  Funds |  | 2018-11-25 00:00:00
28 | 1904 | 1500 | Fee &  Funds |  | 2018-11-26 00:00:00
29 | 1230 | 1100 | Fee &  Funds |  | 2018-11-26 00:00:00
30 | 7159 | 50 | For Syllabus |  | 2018-11-25 00:00:00
31 | 7814 | 1500 | For Syllabus |  | 2018-11-25 00:00:00
32 | 7819 | 1000 | For Syllabus |  | 2018-11-26 00:00:00
33 | 7819 | 1000 | For Syllabus |  | 2018-11-26 00:00:00
34 |  | 200 | Other | Canteen | 2018-11-25 00:00:00
35 |  | 90 | Other | Fine | 2018-11-25 00:00:00
36 |  | 150 | Other | Fee Card | 2018-11-26 00:00:00