Find a match if not blank

Hi I want to do some verification so I am currently using

Please Login or Register  to view this content.

So what i want to do is check output with user inputs.

E.g. OUTPUT USER INPUT

Column G H I J K R S T U V Output I wish to get
10 10 10 10 10 10 10 10 10 10 Match
2 1 1 1 1 2 Match (Since user input was only 2 and rest are blank and in output
corresponding to the user input column is the same I want it as a match
2 1 1 1 1 2 2 MisMATCH since column 2 is not the same.
1 2 1 1 1 2 Match (Since user input was only 2 (2nd column)and rest are blank and in
Output corresponding to the user input column is the same. I want it as a match


So prettymuch i want it to compare compare columns if there is a user input, if it is blank do not worry. I used

Please Login or Register  to view this content.

to shee the number of user for the row and then use that value to sum within the range. if the sum is right then it is a match.

Please Login or Register  to view this content.

e.g. if user input is 2, then I would get a count of 1 since columns STUV all would be blank and only Column R has 2. Then it will check Sum only R = 2, then in the output it only sums G since count is 1 and I am using that as an offset in sum. but this doesnt work if i have a Blank and then a number. The count will still be one but value is on the second column. when checking, it uses offset and only look at the fisrt column, where value is 1. not 2. so it comes as a mismatch while it is a match.

Any help is appreciated.

Thanks

Hi,

I have deleted contents from Column B and C, M and N for privacy reasons.

As you can see only row 142 is FALSE because it has a Blank and then 2 in column R and S.


Any help is appreciated.

Thanks