Multi Data Comparision
here is my question, i have two sets of data in excel related to sales,
both have 100 rows and 50 coloum both sheets have same order of coloum
in first table the data are in some order and in second sheet the data are scrambled
for eg,in sheet1 1st row data may present in sheet2 100th row but the data is available the position is just changing,how to validate or compare this data
how to validate a range of values(group) in a range array is my question ?
a few ways Formula way: 1. If
a few ways
Formula way:
1. If you can sort the data so that the entries are the same, create a new sheet with a formula to compare the same cell from the other 2 sheets
Pivot Table Way
2. create a new column called "source" on both sheets.
- source should be "source1" / "source2" or whatever
- create a new sheet and paste both sets of data underneath each other
- Create a pivot table from the new sheet, and add "source" to the column field
- add the unique identifier to the "row" section of the pivot
- Add whatever field(s) you want to compare to the "data" section of the pivot
Nick