Forum Discussion
Formula
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")
- 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
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.
- Thanks a lot
