Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to get the unique values between 2 columns. For example, if A has
2,3,4,5 & 7 and B has 1,2,3,4,and 5, I need something to tell me that B doesn't have 7. I expect to run through it again so that I see that A doesn't have 1. I do not wish to enter in the data to search for, but rather have a column comparison and kickout the differences (similar to a diff command on Unix for those that know it). Any help would be appreciated. The advanced filter doesn't do what I need as it would give me all values. Thanks, Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Creating a chart with values from two columns | Charts and Charting in Excel | |||
interchange columns with rows | Excel Discussion (Misc queries) |