|
BLEND() function
Has anyone ever heard of a function which combines the
content of two rows or cells -or organizes (sorts) those rows or cells dependent on the presence of a specific character string? ie: NAME DESC P MGR P NAME Terry RD Chris Blue T CDV, Blue T STD Jana CS Jim PRS CONV Jo RD Chris, Jim Blue T STD, PRS CONV Don RC Pam LTS GOLD D Jack RD Chris Blue T STD Anne CS Jim PRS CONV David RD Chris LST GOLD D Ed RC Chris Blue T CDV, Blue T STD Tim RC Chris, Pam Blue T CDV, LTS GOLD D RESULT of BLEND() P NAME P MGR TEAM Blue T CDV Chris Terry RD, Tim RC, Ed RC Blue T STD Chris Jo RD, Jack RD, Ed RC, Terry RD LTS GOLD D Pam David RD, Don RC, Tim RC, PRS CONV Jim Jana CS, Anne CS, Jo RD |
I imagine one could write such a function but it might be better for
you to consider the tools available for use with a relational database. If you are not averse to reorganizing your data, consider breaking up your data into: Table 1: Person information PersonID Name Desc other-info 1 Terry RD 2 Jana CS etc. Table 2: Program Info PgmID Name Mgr 1 Blue T CDV Chris 2 Blue T STD Chris 3 PRS CONV Jim etc. Table 3: Team composition PersonID ProgramID 1 1 1 2 2 3 etc. Now, a simple query using all three tables will give you the result. The default form would be: Blue T CDV Chris Terry RD Blue T CDV Chris Tim RC Blue T CDV Chris Ed RC For more see Building and using a relational database in Excel (with a little help from MS Query) http://www.tushar-mehta.com/excel/ne...cel/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , firstvet52 @netzero.net says... Has anyone ever heard of a function which combines the content of two rows or cells -or organizes (sorts) those rows or cells dependent on the presence of a specific character string? ie: NAME DESC P MGR P NAME Terry RD Chris Blue T CDV, Blue T STD Jana CS Jim PRS CONV Jo RD Chris, Jim Blue T STD, PRS CONV Don RC Pam LTS GOLD D Jack RD Chris Blue T STD Anne CS Jim PRS CONV David RD Chris LST GOLD D Ed RC Chris Blue T CDV, Blue T STD Tim RC Chris, Pam Blue T CDV, LTS GOLD D RESULT of BLEND() P NAME P MGR TEAM Blue T CDV Chris Terry RD, Tim RC, Ed RC Blue T STD Chris Jo RD, Jack RD, Ed RC, Terry RD LTS GOLD D Pam David RD, Don RC, Tim RC, PRS CONV Jim Jana CS, Anne CS, Jo RD |
|
Thanks! I'm making this inquiry on behalf of a former
colleage and I have never heard of a BLEND() function. I sent the same reply to her last week that you sent to me, but she insists there is a BLEND() function out there. I suspect that someone in her organization wrote a user- defined function for a similar purpose. Thanks again! Vette -----Original Message----- I imagine one could write such a function but it might be better for you to consider the tools available for use with a relational database. If you are not averse to reorganizing your data, consider breaking up your data into: Table 1: Person information PersonID Name Desc other-info 1 Terry RD 2 Jana CS etc. Table 2: Program Info PgmID Name Mgr 1 Blue T CDV Chris 2 Blue T STD Chris 3 PRS CONV Jim etc. Table 3: Team composition PersonID ProgramID 1 1 1 2 2 3 etc. Now, a simple query using all three tables will give you the result. The default form would be: Blue T CDV Chris Terry RD Blue T CDV Chris Tim RC Blue T CDV Chris Ed RC For more see Building and using a relational database in Excel (with a little help from MS Query) http://www.tushar- mehta.com/excel/newsgroups/rdbms_in_excel/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , firstvet52 says... Has anyone ever heard of a function which combines the content of two rows or cells -or organizes (sorts) those rows or cells dependent on the presence of a specific character string? ie: NAME DESC P MGR P NAME Terry RD Chris Blue T CDV, Blue T STD Jana CS Jim PRS CONV Jo RD Chris, Jim Blue T STD, PRS CONV Don RC Pam LTS GOLD D Jack RD Chris Blue T STD Anne CS Jim PRS CONV David RD Chris LST GOLD D Ed RC Chris Blue T CDV, Blue T STD Tim RC Chris, Pam Blue T CDV, LTS GOLD D RESULT of BLEND() P NAME P MGR TEAM Blue T CDV Chris Terry RD, Tim RC, Ed RC Blue T STD Chris Jo RD, Jack RD, Ed RC, Terry RD LTS GOLD D Pam David RD, Don RC, Tim RC, PRS CONV Jim Jana CS, Anne CS, Jo RD . |
It may be "out there", but "there" isn't Excel <g.
On Tue, 28 Dec 2004 07:47:09 -0800, wrote: Thanks! I'm making this inquiry on behalf of a former colleage and I have never heard of a BLEND() function. I sent the same reply to her last week that you sent to me, but she insists there is a BLEND() function out there. I suspect that someone in her organization wrote a user- defined function for a similar purpose. Thanks again! Vette -----Original Message----- I imagine one could write such a function but it might be better for you to consider the tools available for use with a relational database. If you are not averse to reorganizing your data, consider breaking up your data into: Table 1: Person information PersonID Name Desc other-info 1 Terry RD 2 Jana CS etc. Table 2: Program Info PgmID Name Mgr 1 Blue T CDV Chris 2 Blue T STD Chris 3 PRS CONV Jim etc. Table 3: Team composition PersonID ProgramID 1 1 1 2 2 3 etc. Now, a simple query using all three tables will give you the result. The default form would be: Blue T CDV Chris Terry RD Blue T CDV Chris Tim RC Blue T CDV Chris Ed RC For more see Building and using a relational database in Excel (with a little help from MS Query) http://www.tushar- mehta.com/excel/newsgroups/rdbms_in_excel/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , firstvet52 says... Has anyone ever heard of a function which combines the content of two rows or cells -or organizes (sorts) those rows or cells dependent on the presence of a specific character string? ie: NAME DESC P MGR P NAME Terry RD Chris Blue T CDV, Blue T STD Jana CS Jim PRS CONV Jo RD Chris, Jim Blue T STD, PRS CONV Don RC Pam LTS GOLD D Jack RD Chris Blue T STD Anne CS Jim PRS CONV David RD Chris LST GOLD D Ed RC Chris Blue T CDV, Blue T STD Tim RC Chris, Pam Blue T CDV, LTS GOLD D RESULT of BLEND() P NAME P MGR TEAM Blue T CDV Chris Terry RD, Tim RC, Ed RC Blue T STD Chris Jo RD, Jack RD, Ed RC, Terry RD LTS GOLD D Pam David RD, Don RC, Tim RC, PRS CONV Jim Jana CS, Anne CS, Jo RD . |
| All times are GMT +1. The time now is 10:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com