I suggest you to do it in Pivot Table, because it can be done easily by using
Pivot Table in less than a minute time.

--------------------
(MS-Exl-Learner)
--------------------



"Pritesh" wrote:

I have huge data containing running project details, wherein I need to
list-out Names of Projects under various Managers. So a manager can have 1 or
2 or 10 projects under him.

Pls suggest me solution/formula based on below output requirement.

Example Input:

A B
1 Mngr1 Proj1
2 Mngr2 Proj3
3 Mngr1 Proj2
4 Mngr1 Proj5
5 Mngr2 Proj4


Example- Reqd Output:

A B
1 Mngr1 Proj1
2 Mngr1 Proj2
3 Mngr1 Proj5
4
5 Mngr2 Proj3
6 Mngr2 Proj4
7


Regards,
Pritesh