Extract data between two sets of dates in two columns.

[Kannie]

Hallo everyone.

Thanks in advance for any assistance you can provide.

I need to create a report and extract only the rows between the Build Start Date-H1, Build End Date-H2 in column A, Dismantle Start Date-J1 and Dismantle End Date-J2 in column B. Some of the records will only be applicable to the Build date in column A or Dismantle date in Column B and some will be a combination of both as I highlighted them in yellow based on my input dates in H1, .There will also be blank cells in column B. The certificate column C contains unique values. How would I construct the formulas to achieve this?



[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]
​

[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​

[/TD]
[TD="bgcolor: #8DB4E2"]

Build Date​

[/TD]
[TD="bgcolor: #8DB4E2"]

Dismantle date​

[/TD]
[TD="bgcolor: #8DB4E2"]

Certificate​

[/TD]
[TD="bgcolor: #8DB4E2"]

Build Cost​

[/TD]
[TD="bgcolor: #8DB4E2"]

Dismantle Cost​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF00"]Build Start Date[/TD]
[TD]

2018-08-01​

[/TD]
[TD="bgcolor: #FFFF00"]Dismantle Start Date[/TD]
[TD]

2018-08-01​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​

[/TD]
[TD]

2018-04-15​

[/TD]
[TD]

2018-04-21​

[/TD]
[TD]

8100​

[/TD]
[TD]

R 1 000.00​

[/TD]
[TD]

R 5 000.00​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF00"]Build End Date[/TD]
[TD]

2018-08-17​

[/TD]
[TD="bgcolor: #FFFF00"]Dismantle End Date[/TD]
[TD]

2018-08-17​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​

[/TD]
[TD]

2018-04-18​

[/TD]
[TD]

2018-04-22​

[/TD]
[TD]

8101​

[/TD]
[TD]

R 1 100.00​

[/TD]
[TD]

R 5 100.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​

[/TD]
[TD]

2018-04-19​

[/TD]
[TD]

2018-04-23​

[/TD]
[TD]

8102​

[/TD]
[TD]

R 1 200.00​

[/TD]
[TD]

R 5 200.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​

[/TD]
[TD]

2018-04-20​

[/TD]
[TD]

2018-04-24​

[/TD]
[TD]

8103​

[/TD]
[TD]

R 1 300.00​

[/TD]
[TD]

R 5 300.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​

[/TD]
[TD]

2018-05-02​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-01​

[/TD]
[TD]

8104​

[/TD]
[TD]

R 1 400.00​

[/TD]
[TD]

R 5 400.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​

[/TD]
[TD]

2018-05-03​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-02​

[/TD]
[TD]

8105​

[/TD]
[TD]

R 1 500.00​

[/TD]
[TD]

R 5 500.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​

[/TD]
[TD]

2018-05-04​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-03​

[/TD]
[TD]

8106​

[/TD]
[TD]

R 1 600.00​

[/TD]
[TD]

R 5 600.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​

[/TD]
[TD]

2018-05-05​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-04​

[/TD]
[TD]

8107​

[/TD]
[TD]

R 1 700.00​

[/TD]
[TD]

R 5 700.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​

[/TD]
[TD]

2018-05-06​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-05​

[/TD]
[TD]

8108​

[/TD]
[TD]

R 1 800.00​

[/TD]
[TD]

R 5 800.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-01​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-06​

[/TD]
[TD]

8109​

[/TD]
[TD]

R 1 900.00​

[/TD]
[TD]

R 5 900.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-02​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-07​

[/TD]
[TD]

8110​

[/TD]
[TD]

R 2 000.00​

[/TD]
[TD]

R 6 000.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-03​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-08​

[/TD]
[TD]

8111​

[/TD]
[TD]

R 2 100.00​

[/TD]
[TD]

R 6 100.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-04​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-09​

[/TD]
[TD]

8112​

[/TD]
[TD]

R 2 200.00​

[/TD]
[TD]

R 6 200.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-05​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-10​

[/TD]
[TD]

8113​

[/TD]
[TD]

R 2 300.00​

[/TD]
[TD]

R 6 300.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-12​

[/TD]
[TD][/TD]
[TD]

8114​

[/TD]
[TD]

R 2 400.00​

[/TD]
[TD]

R 6 400.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-13​

[/TD]
[TD][/TD]
[TD]

8115​

[/TD]
[TD]

R 2 500.00​

[/TD]
[TD]

R 6 500.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-14​

[/TD]
[TD][/TD]
[TD]

8116​

[/TD]
[TD]

R 2 600.00​

[/TD]
[TD]

R 6 600.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-15​

[/TD]
[TD][/TD]
[TD]

8117​

[/TD]
[TD]

R 2 700.00​

[/TD]
[TD]

R 6 700.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-16​

[/TD]
[TD][/TD]
[TD]

8118​

[/TD]
[TD]

R 2 800.00​

[/TD]
[TD]

R 6 800.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]

2018-08-17​

[/TD]
[TD][/TD]
[TD]

8119​

[/TD]
[TD]

R 2 900.00​

[/TD]
[TD]

R 6 900.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR]​

[/TD]
[TD]

2018-08-18​

[/TD]
[TD][/TD]
[TD]

8119​

[/TD]
[TD]

R 2 900.00​

[/TD]
[TD]

R 6 900.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]23[/COLOR]​

[/TD]
[TD]

2018-08-19​

[/TD]
[TD][/TD]
[TD]

8119​

[/TD]
[TD]

R 2 900.00​

[/TD]
[TD]

R 6 900.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]24[/COLOR]​

[/TD]
[TD]

2018-08-20​

[/TD]
[TD][/TD]
[TD]

8119​

[/TD]
[TD]

R 2 900.00​

[/TD]
[TD]

R 6 900.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]25[/COLOR]​

[/TD]
[TD]

2018-08-21​

[/TD]
[TD][/TD]
[TD]

8119​

[/TD]
[TD]

R 2 900.00​

[/TD]
[TD]

R 6 900.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]26[/COLOR]​

[/TD]
[TD]

2018-08-22​

[/TD]
[TD][/TD]
[TD]

8119​

[/TD]
[TD]

R 2 900.00​

[/TD]
[TD]

R 6 900.00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[RasGhul]

	A	B	C	D	E	F	G	H	I	J	K	L
Build Date	Dismantle date	Certificate	Build Cost	Build Cost1	Dismantle Cost	Dismantle Cost1	Build Start Date	Dismantle Start Date
R 1 000.00	R 5 000.00	Build End Date	Dismantle End Date
R 1 100.00	R 5 100.00
R 1 200.00	R 5 200.00
R 1 300.00	R 5 300.00
R 1 400.00	R 5 400.00	Build Cost
R 1 500.00	R 5 500.00	Dismantle Cost
R 1 600.00	R 5 600.00
R 1 700.00	R 5 700.00
R 1 800.00	R 5 800.00	TOTAL
R 1 900.00	R 5 900.00
R 2 000.00	R 6 000.00
R 2 100.00	R 6 100.00
R 2 200.00	R 6 200.00
R 2 300.00	R 6 300.00
R 2 400.00	R 6 400.00
R 2 500.00	R 6 500.00
R 2 600.00	R 6 600.00
R 2 700.00	R 6 700.00
R 2 800.00	R 6 800.00
R 2 900.00	R 6 900.00
R 2 900.00	R 6 900.00
R 2 900.00	R 6 900.00
R 2 900.00	R 6 900.00
R 2 900.00	R 6 900.00
R 2 900.00	R 6 900.00

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: right"]01-08-18[/TD]

[TD="align: right"]01-08-18[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]15-04-18[/TD]
[TD="align: right"]21-04-18[/TD]
[TD="align: right"]8100[/TD]

[TD="align: right"]$1,000.00[/TD]

[TD="align: right"]$5,000.00[/TD]
[TD="align: right"][/TD]

[TD="align: right"]17-08-18[/TD]

[TD="align: right"]17-08-18[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]18-04-18[/TD]
[TD="align: right"]22-04-18[/TD]
[TD="align: right"]8101[/TD]

[TD="align: right"]$1,100.00[/TD]

[TD="align: right"]$5,100.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]19-04-18[/TD]
[TD="align: right"]23-04-18[/TD]
[TD="align: right"]8102[/TD]

[TD="align: right"]$1,200.00[/TD]

[TD="align: right"]$5,200.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]20-04-18[/TD]
[TD="align: right"]24-04-18[/TD]
[TD="align: right"]8103[/TD]

[TD="align: right"]$1,300.00[/TD]

[TD="align: right"]$5,300.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]02-05-18[/TD]
[TD="align: right"]01-08-18[/TD]
[TD="align: right"]8104[/TD]

[TD="align: right"]$1,400.00[/TD]

[TD="align: right"]$5,400.00[/TD]
[TD="align: right"][/TD]

[TD="align: right"]$26,400.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]03-05-18[/TD]
[TD="align: right"]02-08-18[/TD]
[TD="align: right"]8105[/TD]

[TD="align: right"]$1,500.00[/TD]

[TD="align: right"]$5,500.00[/TD]
[TD="align: right"][/TD]

[TD="align: right"]$58,500.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]04-05-18[/TD]
[TD="align: right"]03-08-18[/TD]
[TD="align: right"]8106[/TD]

[TD="align: right"]$1,600.00[/TD]

[TD="align: right"]$5,600.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]05-05-18[/TD]
[TD="align: right"]04-08-18[/TD]
[TD="align: right"]8107[/TD]

[TD="align: right"]$1,700.00[/TD]

[TD="align: right"]$5,700.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]06-05-18[/TD]
[TD="align: right"]05-08-18[/TD]
[TD="align: right"]8108[/TD]

[TD="align: right"]$1,800.00[/TD]

[TD="align: right"]$5,800.00[/TD]
[TD="align: right"][/TD]

[TD="align: right"]$84,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]01-08-18[/TD]
[TD="align: right"]06-08-18[/TD]
[TD="align: right"]8109[/TD]

[TD="align: right"]$1,900.00[/TD]

[TD="align: right"]$5,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]02-08-18[/TD]
[TD="align: right"]07-08-18[/TD]
[TD="align: right"]8110[/TD]

[TD="align: right"]$2,000.00[/TD]

[TD="align: right"]$6,000.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]03-08-18[/TD]
[TD="align: right"]08-08-18[/TD]
[TD="align: right"]8111[/TD]

[TD="align: right"]$2,100.00[/TD]

[TD="align: right"]$6,100.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]04-08-18[/TD]
[TD="align: right"]09-08-18[/TD]
[TD="align: right"]8112[/TD]

[TD="align: right"]$2,200.00[/TD]

[TD="align: right"]$6,200.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]05-08-18[/TD]
[TD="align: right"]10-08-18[/TD]
[TD="align: right"]8113[/TD]

[TD="align: right"]$2,300.00[/TD]

[TD="align: right"]$6,300.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]12-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8114[/TD]

[TD="align: right"]$2,400.00[/TD]

[TD="align: right"]$6,400.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]13-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8115[/TD]

[TD="align: right"]$2,500.00[/TD]

[TD="align: right"]$6,500.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]14-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8116[/TD]

[TD="align: right"]$2,600.00[/TD]

[TD="align: right"]$6,600.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]15-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8117[/TD]

[TD="align: right"]$2,700.00[/TD]

[TD="align: right"]$6,700.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]16-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8118[/TD]

[TD="align: right"]$2,800.00[/TD]

[TD="align: right"]$6,800.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]17-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8119[/TD]

[TD="align: right"]$2,900.00[/TD]

[TD="align: right"]$6,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]18-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8119[/TD]

[TD="align: right"]$2,900.00[/TD]

[TD="align: right"]$6,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]19-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8119[/TD]

[TD="align: right"]$2,900.00[/TD]

[TD="align: right"]$6,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]20-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8119[/TD]

[TD="align: right"]$2,900.00[/TD]

[TD="align: right"]$6,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]21-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8119[/TD]

[TD="align: right"]$2,900.00[/TD]

[TD="align: right"]$6,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]22-08-18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8119[/TD]

[TD="align: right"]$2,900.00[/TD]

[TD="align: right"]$6,900.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

Note that I added Column E & G, to convert your data into numbers for sum;

Build Cost

=SUMIFS($E$2:$E$26,$A$2:$A$26,">="&$J$1,$A$2:$A$26,"<="&$J$2)

Dismantle Cost

=SUMIFS($G$2:$G$26,$B$2:$B$26,">="&$L$1,$B$2:$B$26,"<="&$L$2)

Column E Drag Down

=VALUE(SUBSTITUTE(SUBSTITUTE(D2,"R ","")," ",""))

Column G Drag Down

=VALUE(SUBSTITUTE(SUBSTITUTE(F2,"R ","")," ",""))

 

[Kannie]

Thanks for the reply RasGhul

Your formulas are working but I don't want to sum the values between the criteria range in Column A and B. I want to extract all the records that fall within that criteria range to another sheet in the same workbook. The records I want extracted falls in this range A6:E21 from the table in my post. Would that be possible?

 

[RasGhul]

Argh extract sorry,

Don't forget you will need to change your Sheet references if you have named them;

Book1
	A	B	C
1	Build Date	Certificate	Build Cost
2	01-08-18	8109	R 1 900.00
3	02-08-18	8110	R 2 000.00
4	03-08-18	8111	R 2 100.00
5	04-08-18	8112	R 2 200.00
6	05-08-18	8113	R 2 300.00
7	12-08-18	8114	R 2 400.00
8	13-08-18	8115	R 2 500.00
9	14-08-18	8116	R 2 600.00
10	15-08-18	8117	R 2 700.00
11	16-08-18	8118	R 2 800.00
12	17-08-18	8119	R 2 900.00
Sheet2

Cell Formulas
Range	Formula
A2	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A2))),"")}
A3	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A3))),"")}
A4	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A4))),"")}
A5	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A5))),"")}
A6	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A6))),"")}
A7	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A7))),"")}
A8	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A8))),"")}
A9	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A9))),"")}
A10	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A10))),"")}
A11	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A11))),"")}
A12	{=IFERROR(INDEX(Sheet1!A$2:A$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A12))),"")}
B2	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A2))),"")}
B3	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A3))),"")}
B4	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A4))),"")}
B5	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A5))),"")}
B6	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A6))),"")}
B7	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A7))),"")}
B8	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A8))),"")}
B9	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A9))),"")}
B10	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A10))),"")}
B11	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A11))),"")}
B12	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A12))),"")}
C2	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A2))),"")}
C3	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A3))),"")}
C4	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A4))),"")}
C5	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A5))),"")}
C6	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A6))),"")}
C7	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A7))),"")}
C8	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A8))),"")}
C9	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A9))),"")}
C10	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A10))),"")}
C11	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A11))),"")}
C12	{=IFERROR(INDEX(Sheet1!D$2:D$26,SMALL(IF(Sheet1!A$2:A$26>=Sheet1!$H$1,IF(Sheet1!A$2:A$26<=Sheet1!$H$2,ROW(Sheet1!$A$2:$A$26)-ROW(Sheet1!$A$2)+1)),ROWS(Sheet2!A$2:A12))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Book1
	A	B	C
14	Dismantle date	Certificate	Dismantle Cost
15	01-08-18	8104	R 5 400.00
16	02-08-18	8105	R 5 500.00
17	03-08-18	8106	R 5 600.00
18	04-08-18	8107	R 5 700.00
19	05-08-18	8108	R 5 800.00
20	06-08-18	8109	R 5 900.00
21	07-08-18	8110	R 6 000.00
22	08-08-18	8111	R 6 100.00
23	09-08-18	8112	R 6 200.00
24	10-08-18	8113	R 6 300.00
Sheet2

Cell Formulas
Range	Formula
A15	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
A16	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
A17	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
A18	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
A19	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
A20	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
A21	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
A22	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
A23	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
A24	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
B15	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
B16	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
B17	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
B18	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
B19	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
B20	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
B21	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
B22	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
B23	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
B24	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
C15	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
C16	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
C17	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
C18	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
C19	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
C20	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
C21	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
C22	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
C23	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
C24	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$H$1,IF(Sheet1!B$2:B$26<=Sheet1!$H$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[RasGhul]

Use the following for the Dismantle table, I noticed they were looking at the Build dates in error;

Book1
	A	B	C
14	Dismantle date	Certificate	Dismantle Cost
15	01-08-18	8104	R 5 400.00
16	02-08-18	8105	R 5 500.00
17	03-08-18	8106	R 5 600.00
18	04-08-18	8107	R 5 700.00
19	05-08-18	8108	R 5 800.00
20	06-08-18	8109	R 5 900.00
21	07-08-18	8110	R 6 000.00
22	08-08-18	8111	R 6 100.00
23	09-08-18	8112	R 6 200.00
24	10-08-18	8113	R 6 300.00
Sheet2

Cell Formulas
Range	Formula
A15	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
A16	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
A17	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
A18	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
A19	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
A20	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
A21	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
A22	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
A23	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
A24	{=IFERROR(INDEX(Sheet1!B$2:B$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
B15	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
B16	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
B17	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
B18	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
B19	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
B20	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
B21	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
B22	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
B23	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
B24	{=IFERROR(INDEX(Sheet1!C$2:C$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
C15	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A15))),"")}
C16	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A16))),"")}
C17	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A17))),"")}
C18	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A18))),"")}
C19	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A19))),"")}
C20	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A20))),"")}
C21	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A21))),"")}
C22	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A22))),"")}
C23	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A23))),"")}
C24	{=IFERROR(INDEX(Sheet1!E$2:E$26,SMALL(IF(Sheet1!B$2:B$26>=Sheet1!$J$1,IF(Sheet1!B$2:B$26<=Sheet1!$J$2,ROW(Sheet1!B$2:B$26)-ROW(Sheet1!$B$2)+1)),ROWS(Sheet2!$A$15:A24))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.