假设我有类似以下格式的电子表格数据。我想找到为特定经理工作的员工姓名。有人能帮我解决这个问题吗?我已经能够使用数据透视表获取特定经理的员工人数。但获取他们的个人姓名却带来了问题。如果这个问题太过新手,我很抱歉。我对此还很陌生。
Name Department Reporting Mgr
Neeraj Kanth Support Vinod Kumar Bhugari
Manoj Soni Technical Sunil Kumar Sharma
Amar Deep Gupta Technical Sukhdev Singh
Suresh Kapoor Management Anil Baid
Deepak Arora Technical Munish Gupta
Anjan Chakrabarty Technical Sukhdev Singh
Pravin Kumar Jha Support Vinod Kumar Bhugari
Shipra Shekhar BD Anil Baid
Vinod Parate Technical Anchit Sharma
B. Vamsi Krishna Technical Munish Gupta
Raman Kumar Raman Technical Sunil Kumar Sharma
Prashant Kumar Technical Sukhdev Singh
谢谢