lacviet2005
01-24-2014, 05:15 PM
Hi all,
I have two columns of data in an Excel 2010 spreadsheet. A is Quote_Number and Column B is Sale_Rep. There will be multiple values in Column B for each Quote_Number in Column A.
What I want to achieve is to display all of the values for each Quote_Number in another cell, separated by commas.
For example:
A B
------------------------------
| Quote_Number | Sales_Rep |
------------------------------
| 1001 | Doe, John |
| 1002 | Smith, B |
| 1003 | Bob, D |
| 1004 | Doe, John |
| 1005 | Doe, John |
| 1006 | Bob, D |
| 1007 | Bob, D |
| 1008 | Doe, John |
-----------------------------
I'd want to display the following in cell D: 1001, 1004, 1005, 1008
Can this be achieved with a formula? I've been Googling for help, but none. Please help!
Thank you.
I have two columns of data in an Excel 2010 spreadsheet. A is Quote_Number and Column B is Sale_Rep. There will be multiple values in Column B for each Quote_Number in Column A.
What I want to achieve is to display all of the values for each Quote_Number in another cell, separated by commas.
For example:
A B
------------------------------
| Quote_Number | Sales_Rep |
------------------------------
| 1001 | Doe, John |
| 1002 | Smith, B |
| 1003 | Bob, D |
| 1004 | Doe, John |
| 1005 | Doe, John |
| 1006 | Bob, D |
| 1007 | Bob, D |
| 1008 | Doe, John |
-----------------------------
I'd want to display the following in cell D: 1001, 1004, 1005, 1008
Can this be achieved with a formula? I've been Googling for help, but none. Please help!
Thank you.