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?
<tbody>
</tbody>
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?
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR] | |
---|---|---|---|---|---|---|---|---|---|---|
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR] | Build Date | Dismantle date | Certificate | Build Cost | Dismantle Cost | Build Start Date | 2018-08-01 | Dismantle Start Date | 2018-08-01 | |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR] | 2018-04-15 | 2018-04-21 | 8100 | R 1 000.00 | R 5 000.00 | Build End Date | 2018-08-17 | Dismantle End Date | 2018-08-17 | |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR] | 2018-04-18 | 2018-04-22 | 8101 | R 1 100.00 | R 5 100.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR] | 2018-04-19 | 2018-04-23 | 8102 | R 1 200.00 | R 5 200.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR] | 2018-04-20 | 2018-04-24 | 8103 | R 1 300.00 | R 5 300.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR] | 2018-05-02 | 2018-08-01 | 8104 | R 1 400.00 | R 5 400.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR] | 2018-05-03 | 2018-08-02 | 8105 | R 1 500.00 | R 5 500.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR] | 2018-05-04 | 2018-08-03 | 8106 | R 1 600.00 | R 5 600.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR] | 2018-05-05 | 2018-08-04 | 8107 | R 1 700.00 | R 5 700.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR] | 2018-05-06 | 2018-08-05 | 8108 | R 1 800.00 | R 5 800.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR] | 2018-08-01 | 2018-08-06 | 8109 | R 1 900.00 | R 5 900.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR] | 2018-08-02 | 2018-08-07 | 8110 | R 2 000.00 | R 6 000.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR] | 2018-08-03 | 2018-08-08 | 8111 | R 2 100.00 | R 6 100.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR] | 2018-08-04 | 2018-08-09 | 8112 | R 2 200.00 | R 6 200.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR] | 2018-08-05 | 2018-08-10 | 8113 | R 2 300.00 | R 6 300.00 | |||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR] | 2018-08-12 | 8114 | R 2 400.00 | R 6 400.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR] | 2018-08-13 | 8115 | R 2 500.00 | R 6 500.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR] | 2018-08-14 | 8116 | R 2 600.00 | R 6 600.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR] | 2018-08-15 | 8117 | R 2 700.00 | R 6 700.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR] | 2018-08-16 | 8118 | R 2 800.00 | R 6 800.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR] | 2018-08-17 | 8119 | R 2 900.00 | R 6 900.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR] | 2018-08-18 | 8119 | R 2 900.00 | R 6 900.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]23[/COLOR] | 2018-08-19 | 8119 | R 2 900.00 | R 6 900.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]24[/COLOR] | 2018-08-20 | 8119 | R 2 900.00 | R 6 900.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]25[/COLOR] | 2018-08-21 | 8119 | R 2 900.00 | R 6 900.00 | ||||||
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]26[/COLOR] | 2018-08-22 | 8119 | R 2 900.00 | R 6 900.00 |
<tbody>
</tbody>