Hello Everyone
I have a workbook with employee performance, however, the employees ID’s are reflected in several rows. Each row represents other locations; employees occasionally work at other locations, so their ID’s can be found on many rows
I’m trying to write a formula that will find the employees results at a specific location
Example Jose works at Store Number 5555
Jose’s employee ID 24518 is listed in column E in many rows but I only want results for Store Number 5555 and results are in column I
Is this possible?
I have a workbook with employee performance, however, the employees ID’s are reflected in several rows. Each row represents other locations; employees occasionally work at other locations, so their ID’s can be found on many rows
I’m trying to write a formula that will find the employees results at a specific location
Example Jose works at Store Number 5555
Jose’s employee ID 24518 is listed in column E in many rows but I only want results for Store Number 5555 and results are in column I
Is this possible?