Hi, i need some help on two matters. both are related to filters, involving dates and multiple column.
a sample of my database as such:
<tbody>
</tbody>
i need to generate two lists from this database quite frequently and i am hoping to automate it.
the first list is relative simple, i just need to filter gender and date of application, and i am hoping to extract all the corresponding rows into a fresh sheet whenever i key in the date range (at the fresh sheet itself). for example,
<tbody>
</tbody>
the second list is more "complicated". the surveys are done on an adhoc basis so some might be on survey 4 but some might be on their first or not even started yet. i need to filter the rows based on a date range for the survey columns (starting from the second survey onward) that falls between the date range. (is this even possible?)
<tbody>
</tbody>
or is there any better way to do this? appreciate your help and suggestions on this please!
a sample of my database as such:
Name | Project | Gender | Type | Funding | Topic | Date of Application | Survey Date 1 | Survey Date 2 | Survey Date 3 | Survey Date 4 | Survey Date 5 |
<tbody>
</tbody>
i need to generate two lists from this database quite frequently and i am hoping to automate it.
the first list is relative simple, i just need to filter gender and date of application, and i am hoping to extract all the corresponding rows into a fresh sheet whenever i key in the date range (at the fresh sheet itself). for example,
Application Start Date | dd/mm/yyyy | ||
Application End Date | dd/mm/yyyy | ||
Name | Project | Topic | Date of Application |
<tbody>
</tbody>
the second list is more "complicated". the surveys are done on an adhoc basis so some might be on survey 4 but some might be on their first or not even started yet. i need to filter the rows based on a date range for the survey columns (starting from the second survey onward) that falls between the date range. (is this even possible?)
Start Date | 12/02/2019 | ||||||
End Date | 18/03/2019 | ||||||
Name | Project | Gender | Topic | Survey Date 2 | Survey Date 3 | Survey Date 4 | Survey Date 5 |
XXX | XXX | XXX | XXX | 150/2019 | 03/03/2019 | 15/03/2019 | |
XXX | XXX | XXX | XXX | 03/03/2019 | 04/03/2019 | ||
XXX | XXX | XXX | XXX | 08/03/2019 | |||
XXX | XXX | XXX | XXX | 16/03/2019 |
<tbody>
</tbody>
or is there any better way to do this? appreciate your help and suggestions on this please!