This formula does not exclude/chk repetitive ones, and I don't need any
merged outputs.


Regards,
Pritesh


"Mike H" wrote:

Pritesh,

So lets be clear, the following are not suitable or desirable

Filtering
Pivot Table
VB
Clicking buttons.

This seriously limits options, Try this abd drag down

=IF(A2="Mngr1",A2 & " " & B2,"")

Mike



"Pritesh" wrote:

No... Pivot Table, Data Filters, VBA Macros are less suitable for my task. I
need automated list generation, without Refreshing (Pivot) or manually
sorting (Filter) or clicking button or keys (Macros).

Please suggest me some formula.

--
Regards,
Pritesh


"Mattlynn via OfficeKB.com" wrote:

Pritsh
A pivot table could sort and arrange this for you and could be
updated/refreshed as each manager took on more projects etc, or if more
managers were to get involved.
Regards
Matt


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

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1