Compressing List

Hi all,

I am glad to see a forum like this exists! I need help from one of you very talented people in creating a macro for an excel sheet on which I am currently working.

The sheet lists names, job, year worked, and some other information. What need to be able to do is: if the name is the same in say column A, I need the macro to then look at column B. If the jobs are the same in column B, but the years worked are different, I need the macro to list the years in column C. Ultimately, I would want a list that only has one line for each job worked by a person and the years they worked it.

Any help would be appreciated!
Thanks!
MH

Maddhatta, please do not use unnecessary words in the Thread Title, doing so makes the Form Search less efficient. I have removed "Macro" from the title.

Hi MadHatta .. try this:

Please Login or Register  to view this content.

I've assumed your data is in 3 columns - name, ID & title and that the year is always at the end of the title. Hope that helps.

Hi - this should do it ...

Please Login or Register  to view this content.

Hope that helps .. MM.