Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Please help...
I have a really big spreadsheet and would like to find all the unmatched information when comparing two columns in a spreadsheet. Is there any formula or functions to perform this checking, or is there any methods suggested? Example: Info listed In column A: red, blue, green Info listed in column B: blue, violet, black, yellow Result (unmatched info) after comparing column B to column A: violet, black and yellow |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
How can I write vertically in some columns on an Excel spreadshee. | Charts and Charting in Excel | |||
Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
compare columns of different worksheets | Excel Discussion (Misc queries) | |||
Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) |