Hi all,
I've a worksheet with two columns, one with numbers, and the other with repeating dates in a custom format of dd/mm/yyyy for a month when the numbers were recorded, the number of rows will depend on how busy it was so the number of rows will change per month.
e.g.
I'm looking to see if I can filter the worksheet, so that only rows where the date matches a specific day as typed into a cell
e.g If I type in Monday into the cell the list is filtered to only show the dates and numbers that were recorded on a Monday
I've looked at different functions such as workday(), Text() etc and I can filter if I add columns to the worksheet, e.g. C1=TEXT(B1,"dddd") and filter based on this but I'd like to try and not have to add the additional columns and have to filter based on this, and if possible filter the rows just on a day that I enter into a specific cell.
Thanks in advance
I've a worksheet with two columns, one with numbers, and the other with repeating dates in a custom format of dd/mm/yyyy for a month when the numbers were recorded, the number of rows will depend on how busy it was so the number of rows will change per month.
e.g.
100 | 22/06/2020 12:45 |
50 | 22/06/2020 12:46 |
250 | 22/06/2020 13:50 |
80 | 23/06/2020 09:52 |
12 | 23/06/2020 09:52 |
500 | 24/06/2020 10:11 |
785 | 24/06/2020 10:11 |
I'm looking to see if I can filter the worksheet, so that only rows where the date matches a specific day as typed into a cell
e.g If I type in Monday into the cell the list is filtered to only show the dates and numbers that were recorded on a Monday
950 | 15/06/2020 09:18 | Day Filter |
55 | 15/06/2020 15:01 | Monday |
9 | 15/06/2020 17:55 | |
100 | 22/06/2020 12:45 | |
50 | 22/06/2020 12:46 | |
250 | 22/06/2020 13:50 |
I've looked at different functions such as workday(), Text() etc and I can filter if I add columns to the worksheet, e.g. C1=TEXT(B1,"dddd") and filter based on this but I'd like to try and not have to add the additional columns and have to filter based on this, and if possible filter the rows just on a day that I enter into a specific cell.
Thanks in advance