Sumeluar
Active Member
- Joined
- Jun 21, 2006
- Messages
- 275
- Office Version
- 365
- 2016
- 2010
- Platform
- Windows
- MacOS
- Mobile
Greetings!
I have the following formula:
=IFERROR(INDEX('PM Schedule'!$C$3:$F$2500,SMALL(IF(('PM Schedule'!$E$3:$E$2500="Monthly"),MATCH(ROW('PM Schedule'!$C$3:$F$2500),ROW('PM Schedule'!$C$3:$F$2500)),""),ROW($B1)),COLUMN($B1)),"-")
This formula populates from a large list all items all the ones that fit within the date, in this case for the month of January, the tasks are categorized by daily, weekly and monthly, I would like to add another condition that only list the items that correspond to "Monthly", in essence I want to return the items for January 2025 only if the frequency is Monthly.
Date - Equipment - Frequency
01/10/25 - MUA 3 - Monthly
01/17/25 - RTU 1 - Weekly.... and so on.
Thank you in advance.
I have the following formula:
=IFERROR(INDEX('PM Schedule'!$C$3:$F$2500,SMALL(IF(('PM Schedule'!$E$3:$E$2500="Monthly"),MATCH(ROW('PM Schedule'!$C$3:$F$2500),ROW('PM Schedule'!$C$3:$F$2500)),""),ROW($B1)),COLUMN($B1)),"-")
This formula populates from a large list all items all the ones that fit within the date, in this case for the month of January, the tasks are categorized by daily, weekly and monthly, I would like to add another condition that only list the items that correspond to "Monthly", in essence I want to return the items for January 2025 only if the frequency is Monthly.
Date - Equipment - Frequency
01/10/25 - MUA 3 - Monthly
01/17/25 - RTU 1 - Weekly.... and so on.
Thank you in advance.
