limo coney
New Member
- Joined
- Jan 16, 2023
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi everyone,
I've been breaking my head with this one. could you please help me with this formula?
=IF(ISNA(MATCH(BH13,T13:AT13,0)),BH13,IF(ISNA(MATCH(BH13,T13:AT13,0)),M13,IF(ISNA(MATCH(BH13,T13:AT13,0)),N13,"")))
I'm trying to make a roster where formula automatically chooses the next person available if someone's on leave (T13:AT13)
I've been breaking my head with this one. could you please help me with this formula?
=IF(ISNA(MATCH(BH13,T13:AT13,0)),BH13,IF(ISNA(MATCH(BH13,T13:AT13,0)),M13,IF(ISNA(MATCH(BH13,T13:AT13,0)),N13,"")))
I'm trying to make a roster where formula automatically chooses the next person available if someone's on leave (T13:AT13)