Forum Discussion
Solved
return rows from list that matches criteria without blanks
Hello, can you help me with this one, please? I try to create an monthly objective list and track the progress but without success. I attach the excel file here and I'll explain bellow what is t...
=IFERROR(INDEX($B$3:$B$22,SMALL(IF(($C$3:$C$22=C26)*($C$3:$C$22<>""),ROW($B$3:$B$22)-2),ROW(A1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Detlef_Lewin
why is it a bad settup? it helps if you would give more details. I tried my best
My question (in one sentence) would be: how can I built a formula that returns rows from list that matches criteria (the dates) without blanks
thanks!!
why is it a bad settup? it helps if you would give more details. I tried my best
My question (in one sentence) would be: how can I built a formula that returns rows from list that matches criteria (the dates) without blanks
thanks!!
- Detlef_Lewin
I can't have only 1 table because the example from above is only the missing part from my entire project. Each day needs to have its own table because there are more things that are recorded on a daily basis. The objectives are only one of them.
thanks for your suggestion! 🙂