Forum Discussion

Copper Contributor

Sep 01, 2022

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...

admin

excel

Formulas and Functions

office 365

HansVogelaar
Sep 01, 2022
Jonathan_Pineiro

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")

HansVogelaar

MVP

Sep 01, 2022

Jonathan_Pineiro

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")

Jonathan_Pineiro

Copper Contributor

Sep 01, 2022

WHAT NUMBER OR LETTER SHOULD I CHANGE SO I CAN REPEAT THE SAME FORMULA FOR THE NEXT ROW LIKE A4;A5;A6 ETC? I TRIED CHANGING. ALSO IF I WANT TO EXPEND SO IT CAN COPY UP TO CELL K, WHEREN SHOULD I PUT IT? I TRIED CHANGING F FOR K ON THE FORMULA BUT THAT DIDNT WORK. IM SORRY I NEVERD USED EXCEL BEFORE SO YOU ARE REALLY HELPING ME A LOT. THANKS IN ADVANCE

HansVogelaar
MVP
Sep 01, 2022
Jonathan_Pineiro

Do you have Microsoft 365 or Office 2021? If so, you need to enter the formula in one cell only and Excel will fill as many rows as needed for you. And to extend to column K, use

=FILTER(Sheet1!A3:K1000, Sheet1!E3:E1000=TODAY(), "No Due Dates Today")

But if you have an older version, this formula will not work at all - you should get a #NAME! error.