| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I compare 2 sets of data and highlight differences?
How do I compare two sets of data and highlight the differences if:
-Each set of data has three columns and I am comparing column A in data set 1 to column A in data set 2; column B in data set 1 to column B in data set 2 and so on... -One set of data is properly formatted and the other set of data is in all CAPS. -One set of data may have rows ofrepeated data that should be consolidated into one row before being compared Here are 2 sample data sets to compa Data set 1: D1_ColumnA D1_ColumnB D1_ColumnC Cat United States Black Dog United States Brown Mouse Canada Grey Fish Japan Orange Bird Equador Green D2_COLUMNA D2_COLUMNB D2_COLUMNC CAT UNITED STATES BLACK DOG CANADA BROWN DOG CANADA BROWN MOUSE NETHERLANDS GREY FISH CHINA SILVER BIRD EQUADOR GREEN Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
| How can I highlight every other group of data? | Excel Discussion (Misc queries) | |||
| highlight range if cell contains desired data | New Users to Excel | |||
| Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
| Highlight Data | Excel Discussion (Misc queries) | |||
Threaded Mode
