We help IT Professionals succeed at work.
Get Started

Create a single-column list from a small cube of data in Excel

M_Patton asked
Last Modified: 2016-02-12
We have an Excel workbook with multiple pages to aggregate our credit card expenses.  There is a summary sheet and a sheet for each user's credit card statement which are pulled from their individual Excel workbook.  Each individual person's sheet has a list in cells C2:C26 of the jobs he/she worked on; not all lists will be the same length or contain the same jobs.  I am looking to generate a single list of unique values on the summary sheet.

I am including and example of the type of worksheet.  We would want to dynamically create the list in C2:C26 on the Summary sheet from the data on the other sheets' C2:C26.  VBA macros or formula language are acceptable.
Watch Question
This problem has been solved!
Unlock 2 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE