| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Listing Projects based on Manager Name
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
Hi,
The simplest way is to filter the data on column A to display manager 1 and the assigned projects. Mike "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
No I can't do that, the data keeps changing, its in thousands of rows having
multiple records which keeps repeating. -- Regards, Pritesh "Mike H" wrote: Hi, The simplest way is to filter the data on column A to display manager 1 and the assigned projects. Mike "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
You can try out the below macro. If you are new to macros..
--Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run <selected macro() Sub SortandInsert() Dim lngLastRow As Long, lngRow As Long lngLastRow = Cells(Rows.Count, "A").End(xlUp).Row Range("A1").Resize(lngLastRow, 2).Sort _ Key1:=Range("A1"), Order1:=xlAscending, _ Key2:=Range("B1"), Order2:=xlAscending, _ Orientation:=xlTopToBottom For lngRow = lngLastRow To 2 Step -1 If Range("A" & lngRow) < Range("A" & lngRow - 1) Then _ Rows(lngRow).Insert Next End Sub If this post helps click Yes --------------- Jacob Skaria "Pritesh" wrote: No I can't do that, the data keeps changing, its in thousands of rows having multiple records which keeps repeating. -- Regards, Pritesh "Mike H" wrote: Hi, The simplest way is to filter the data on column A to display manager 1 and the assigned projects. Mike "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
I still think to summarise the info in a pivot and then to copy the pivot and
paste and values to create a list that should look like what you are after. Alternatively, in a separte sheet in the same workbook, link the cells so as you refresh the pivot the list in the new sheet grows accordinbly as a semi- automated list. This method will may take a few minutes to set out, but will then be ready in seconds to use for your purposes. Regards Matt Pritesh wrote: This formula does not exclude/chk repetitive ones, and I don't need any merged outputs. Regards, Pritesh Pritesh, [quoted text clipped - 52 lines] Regards, Pritesh -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200909/1 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listing Projects based on Manager Name
I totally agree Ms-Exl Learner !
Ms-Exl-Learner wrote: 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) -------------------- 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 [quoted text clipped - 24 lines] Regards, Pritesh -- Matt Lynn Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with projects | Excel Discussion (Misc queries) | |||
| Create a row listing based on a lookup value | Excel Worksheet Functions | |||
| Listing data based on a referneced criteria | Excel Worksheet Functions | |||
| Scheduling Projects | Excel Discussion (Misc queries) | |||
| listing values to choose from based on value in another cell | Excel Discussion (Misc queries) | |||
![Pritesh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
