techwalker
New Member
- Joined
- Aug 18, 2020
- Messages
- 2
- Office Version
- 365
- 2016
- Platform
- Windows
- Mobile
- Web
Hello!
I am trying to use either formula above to give me the performance of a specific employee while skipping empty cells. I have VLOOKUPs and several other formulas at play for different cells but the formula I am attempting to create is calling a page that has one or more blank cells for that employees performance. The employee that worked during their first day or two will have no performance on the report and also had no shift assigned, resulting in an empty cell. However, because I am inserting a report that covers a 4 week period (4 week to date), there will sometimes be multiple instances of that employee on the report due to being assigned a shift after day one. How can I create a formula that skips the first instance or two of blank cells only resulting in displaying the cell with a value/performance? I greatly appreciate any suggestions and help!
The specific row I need the formula to apply is row AM. As you can see, the employee does indeed have performance but because they transferred in within the last few weeks (hire date is different than their transfer date), they had shift issues resulting in a blank cell on their first instance in my report. I apologize for the lack of detail, there is sensitive information on these documents (names and accounts have been removed from the image).
Thank you!
I am trying to use either formula above to give me the performance of a specific employee while skipping empty cells. I have VLOOKUPs and several other formulas at play for different cells but the formula I am attempting to create is calling a page that has one or more blank cells for that employees performance. The employee that worked during their first day or two will have no performance on the report and also had no shift assigned, resulting in an empty cell. However, because I am inserting a report that covers a 4 week period (4 week to date), there will sometimes be multiple instances of that employee on the report due to being assigned a shift after day one. How can I create a formula that skips the first instance or two of blank cells only resulting in displaying the cell with a value/performance? I greatly appreciate any suggestions and help!
The specific row I need the formula to apply is row AM. As you can see, the employee does indeed have performance but because they transferred in within the last few weeks (hire date is different than their transfer date), they had shift issues resulting in a blank cell on their first instance in my report. I apologize for the lack of detail, there is sensitive information on these documents (names and accounts have been removed from the image).
Thank you!
