Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining cells conditionally
I need to be able to combine several cells into on cell as a comma
separated list based on a criterion in another cell. For example: A B 1 Part Color 2 123 Green 3 234 Red 4 222 Red 5 9874 Blue On another sheet I like to have: A B 1 Color Parts 2 Green 123 3 Red 234,222 4 Blue 9874 Is this possible? Brian |
#2
|
|||
|
|||
Hi Brian
Check out my website (www.hcts.net.au/tipsandtricks.htm) for a UDF called CONCAT_IF - there's instructions etc ...post back if you need additional assistance. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "bxb7668" wrote in message ... I need to be able to combine several cells into on cell as a comma separated list based on a criterion in another cell. For example: A B 1 Part Color 2 123 Green 3 234 Red 4 222 Red 5 9874 Blue On another sheet I like to have: A B 1 Color Parts 2 Green 123 3 Red 234,222 4 Blue 9874 Is this possible? Brian |
#3
|
|||
|
|||
Thank you Julie. That works great!
Brian "JulieD" wrote in message ... Hi Brian Check out my website (www.hcts.net.au/tipsandtricks.htm) for a UDF called CONCAT_IF - there's instructions etc ...post back if you need additional assistance. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "bxb7668" wrote in message ... I need to be able to combine several cells into on cell as a comma separated list based on a criterion in another cell. For example: A B 1 Part Color 2 123 Green 3 234 Red 4 222 Red 5 9874 Blue On another sheet I like to have: A B 1 Color Parts 2 Green 123 3 Red 234,222 4 Blue 9874 Is this possible? Brian |
#4
|
|||
|
|||
you're welcome, and thanks for the feedback
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "bxb7668" wrote in message ... Thank you Julie. That works great! Brian "JulieD" wrote in message ... Hi Brian Check out my website (www.hcts.net.au/tipsandtricks.htm) for a UDF called CONCAT_IF - there's instructions etc ...post back if you need additional assistance. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "bxb7668" wrote in message ... I need to be able to combine several cells into on cell as a comma separated list based on a criterion in another cell. For example: A B 1 Part Color 2 123 Green 3 234 Red 4 222 Red 5 9874 Blue On another sheet I like to have: A B 1 Color Parts 2 Green 123 3 Red 234,222 4 Blue 9874 Is this possible? Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditionally linking to different cells | Excel Discussion (Misc queries) | |||
Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
combining cells | Excel Discussion (Misc queries) |