• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparing an large input from 2 different dates.

Pranay Vimal

New Member
Hi,

I am trying to create a comparison of inputs from 2 different dates to find out what changed in the latest input from the current one. I have created key to combine all the entries in all the rows of the input and trying to run a match on the keys on both the worksheets. But the match function gives me incorrect outputs. This may be due to the length of the string in each key and hence the error. Is there a better way to do it in excel?

On Latest Input tab in the sample file, in the second column I am getting #Value errors. Can they be resolved? I should not get these errors because these are 2 tabs currently have the same inputs.
 

Attachments

  • Comparison Workbook.xlsx
    83.7 KB · Views: 6
Could You think something like this?
1) I cleared columns A & B from both sheets.
2) I tested to change one cells value, marked with 'green'.
3) Press [Compare]-button to see differences between those sheets.
You could see differences and another values with comments
from both sheets.
 

Attachments

  • Comparison Workbook.xlsb
    54.8 KB · Views: 2
Would this code work in case the two inputs are not sorted in the same order? This works as a Comparator but if I unsort the data, I get most of the cells highlighted but that is not my desired output is. In a case where I unsort the data, then also only the cell with "Endocrine2" should be highlighted. Could something like that be done?
 
This would work better with unsorted... but it's slower, of course.
ID-column is 'the key'.
It marks also 'unmatched' ID if any found.
 

Attachments

  • Comparison Workbook.xlsb
    58.8 KB · Views: 4
Back
Top