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.
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.