Coalharbour
New Member
- Joined
- Jul 7, 2023
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
Hello!
Every month we recieve a monthly access report that has who has come in and out of our shared office space and im tasked with creating reports letting the companies who care what employees are actually using the space vs. working from home. I have been manually deleting lines for months and figured there has to be a better way to do this. I know there are some formulas similar to the following =IFERROR(@_xludf.DUMMYFUNCTION(""COMPUTED_VALUE"""),"John Smith") where it would highlight TRUE or FALUSE but when I tried to input it it didn't work for my file.
Is there a better way to do this/ create a template to make this work?
Thank you, I really appreciate your help
Every month we recieve a monthly access report that has who has come in and out of our shared office space and im tasked with creating reports letting the companies who care what employees are actually using the space vs. working from home. I have been manually deleting lines for months and figured there has to be a better way to do this. I know there are some formulas similar to the following =IFERROR(@_xludf.DUMMYFUNCTION(""COMPUTED_VALUE"""),"John Smith") where it would highlight TRUE or FALUSE but when I tried to input it it didn't work for my file.
Is there a better way to do this/ create a template to make this work?
Thank you, I really appreciate your help