Hi,sorry for that i have attached a fresh file to show the output i need.Instead of selecting the Name i would like to select the highest Mgr level in the drop down(combo box).In the attached file the highest level would be Mgr6.
Thanks and do let me know if you have need any other clarifications.
Bookmarks