Forum Discussion
Solved
Formula
I work for a Freight Transportation Company. Every day we book loads from different brokers and then we sell it to the company drivers. In order for us to get pay for it, we have to make an invoice o...
You could use Sort & Filter > Filter on the Home tab of the ribbon to display filter arrows in the header row. You can then easily filter the data in place.
Alternatively, if you have Microsoft 365 or Office 2021, you can use the FILTER function.
On Sheet2 in cell A2:
=FILTER(Sheet1!A3:F1000, Sheet1!E3:E1000=TODAY(), "No Due Dates Today")
You could use Sort & Filter > Filter on the Home tab of the ribbon to display filter arrows in the header row. You can then easily filter the data in place.
Alternatively, if you have Microsoft 365 or Office 2021, you can use the FILTER function.
On Sheet2 in cell A2:
=FILTER(Sheet1!A3:F1000, Sheet1!E3:E1000=TODAY(), "No Due Dates Today")
Thanks a lot