Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare 5 columns of text and highlight duplicates based on repeti
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare 5 columns of text and highlight duplicates based on repeti
Visit http://www.cpearson.com/Excel/Lists.htm
Then come back if more is needed best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "BarryTheCamper" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare 5 columns of text and highlight duplicates based onrepeti
Excel 2007 PivotTable
No formulas, no programming. With chart and colored icons. http://www.mediafire.com/file/ogy5nazmmwe/01_22_10.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate 2 columns (A2+B2) and compare for duplicates | Excel Discussion (Misc queries) | |||
Find and Highlight duplicates in 5 non-adjacent columns | New Users to Excel | |||
Compare columns for duplicates | New Users to Excel | |||
compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions | |||
Compare cells/columns and highlight matching text strings | Excel Worksheet Functions |