Formula to find same value

[jerryong]

Hi Forum members,

Column A contains numerical unique employee IDs. In the subsequent rows, there are listing of employees with each column representing distinct employee information. In Column K of each row is the employee's Manager ID. Since this is an all-employee file, employees who are Managers will have the same employee ID in Column A as well. Conversely, employees who are NOT Managers, will only have their employee ID appear in Column A, but never in Column K.

I like to built a formula at the last blank column of the file (Column Z) to indicate if an employee is also a Manager (a Yes/No indicator would be fine). For example, Employee #1 (in Row 1) is also a Manager and his Manager ID is listed in Column K with his 2 employees in Row 15 and 16. So, for Employee #1, I like the formula in Row 1, Column Z to show "Yes". But, for Employee #2 (in Row 2) who is NOT a Manager, I like the formula in Column Z to show "No". I tried using a Lookup formula in Column Z but was not successfully. I feel like I need an IF formula, but I am not sure how to write it up.

I would appreciate your help.

Thanks,
Jerry

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jerryong]

Hi Trevor,
Thanks for the suggestion. Attached is the sample workbook that shows the example of what I am trying to accomplish.
I don't see the file attached here but hopefully you can see it.

Regards,
Jerry

[FlameRetired]

In E2 of the attached

Please Login or Register  to view this content.

[FlameRetired]

Another way ... also simpler.

Please Login or Register  to view this content.

[jerryong]

Hi FlameRetired,

Thank you so very much for all your help. You posted 2 solutions and they all worked !!
I should have thought about the CountIF formula - powerful and useful.

Again, many thanks. I appreciate it.

Regards,
Jerry

[FlameRetired]

You are welcome. Glad to help. Thank you for the feedback and marking this thread Solved.