Comparing ranges

Excel17
I am trying to compare two datasets in the same worksheet.



Each data sets will have four key variables. The First two are

identifiers,

the 4th is an output. The third is the text message associated with the



2nd identifier. The dataset in all cases will be

sorted by the first two identifiers: CheckID, CustomerID, and the (4th

variable)

the output. There will be missing records from either datasets. Both

datasets are the same,

except one is dated, and represented as OLD, the other as new.

I am trying to compare or identify for new records in the New Datasets,



and Missing records in the New Datasets. This will be represented

as Removed or New Records. Because of the fact that there will be

missing records in either datasets, and the data is sorted by three

variables,

the rows won't be exactly a match. There may be less in the "New"

dataset.



How can a comparison identify for new & removed records in the 2nd

("NEw") Dataset?



I've written IF statements to compare the for this, but I can

compensate or adapt

for different number of rows for each dataset. Ideally, perhaps this

can be

done through Microsoft Query as a union join, and filtered for two

criteria:

"New Record" or "Deleted Records" (and perhaps "Changed Records")?



I know there are a couple of macros or conditional formatting that can



compare ranges, but I am not sure it solves for this situation.

Thanks.



Robert1





--

Robert1

------------------------------------------------------------------------

Robert1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29270

View this thread: http://www.excelforum.com/showthread.php?threadid=489911


-