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

Hide columns based on row values 2
Highlight rows if duplicates are found 3
Color a cell based on column date and row content 2
How may I lookup and return a value between two numbers 2
compare date range with date in columns and input data from another cell 2
Return an array of data based on range of date 3
Highlight Row Based On Condition-So close 3
Find and Highlight duplicates in 5 non-adjacent columns 3

Top