compare 5 columns of text and highlight duplicates based on repeti

B

BarryTheCamper

I run a summer camp and I have a ws with 5 columns, each representing a
calendar year (2005-2009). The columns each have 500 names (first and last)
of campers that attended that year. I'd like to compare the columns and have
Excel highlight names that appear in more than one column. Preferably with a
color that represents duplication 2x, 3x, 4x or 5x. I'm trying to determine
who attended 2 years, who attended 3 years and so on. The color would be
based on how many years attended rather than individual names. I have Excel
2007 and I'm new at this whole programming stuff. I need help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight rows if duplicates are found 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
compare info in 4 worksheets and highlight fields that are the sam 3
Compare and Highlight Rows 12
Return an array of data based on range of date 3
Find and Highlight duplicates in 5 non-adjacent columns 3
Report: Compare two columns and Highlight Changes 0
Finding near duplicates by comparing two columns 1

Top