BLEND() function

[Firstvet]

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

 

[Tushar Mehta]

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

 

[Guest]

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

 

[Myrna Larson]

It may be "out there", but "there" isn't Excel <g>.

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