| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare data from one column with another and compare result to yet another
I'm not real sure how to go about doing this.
I need to compare one column (ALL - a2:a3793) to see if it has any numbers that are not in another column (ALL AFTER CHG - d2:d2735). Then take the results of that and compare them to another column. (INACTIVE c2:c1056) All of the columns are formatted as text. What is the most efficient way to do this? TIA Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Chart to compare data | Charts and Charting in Excel | |||
| Help! -How to compare two worksheets; multiple rows of data=result | Excel Worksheet Functions | |||
| compare date to column data | Excel Worksheet Functions | |||
| How to compare two column of data and sort them out according | New Users to Excel | |||
| How do I compare data in two different spreadsheets i.e. (column . | Excel Discussion (Misc queries) | |||
![Matt Williamson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
