Hi Amol,

Welcome to our forum! Try this formula in cell D2 of your file, then copy down:

=IF(COUNTIF($B$2:$B$21,"Not Match")=COUNTA($B$2:$B$21),"Please verify","No need to verify")

Mynda

HI Madam,

Thanks for swift reply,

After adding the formula in D2 , i am getting all result as "No Need to verify" against all results.

In first column some ID's are repeated and in second column their results are not same. i want to find out wherever comment mentioned in column "C" as "How I can find out pure "Not Match "entries only" formula ? "Please verify".

Hi Amol,

Unfortunately, your question isn't clear. What has the first and second column data got to do with your formula? You originally said:

"if all results are "Not Match " then result should be "Please verify". if one result is "Match" and one result is "Not Match" then result should be "No need to verify"."

There was no mention of how the Contract ID and Validation Result impacted your result. 

You started to explain in your second post:

"In first column some ID's are repeated and in second column their results are not same. i want to find out wherever comment mentioned in column "C" as "How I can find out pure "Not Match "entries only" formula ? "Please verify"."

But still you don't explain with an example of your desired result and how the ID affects what you want.

Please clarify with an example of what you'd expect to see in the formula column and why.

Thanks,

Mynda

Hi Madam,

Apologies for confusion.

in first column "Contract ID" are repeated/single somewhere. in second column "B" "validation result" are mentioned "Match or not Match". which is depend on column "A" Contract ID.

Now will you please help me to find out, How to find out pure not match result. if all results are "Not Match " in column "B" against mentioned contract ID (whether its single or repeated ) in column "A" then result should be "Please verify". if contract IDs are repeated/single in column "A" and one result (CTR300- Match)  is "Match" and one result (CTR300- Not Match) is "Not Match" mentioned in column "B" then result should be "No need to verify".

Any formula?

once again sorry for confusion and Thanks for your help again.

Many Thanks, Amol

Hi Amol,

Thanks for clarifying. I think if your 'Final Result' column had just said 'Please verify' instead of 'How I can find out pure "Not Match"entries only" formula ?' your example would have made sense to me.

You can use this formula:

=IFERROR(IF(MATCH("MATCH"&A2,$B$2:$B$21&$A$2:$A$21,0),"No need to check"),"Please verify")

Mynda

HI Madam,

Thanks you very much for formula. However its giving result "Please verify " against all entries.

in first column "Contract ID" are repeated/single somewhere. in second column "B" "validation result" are mentioned "Match or not Match". which is depend on column "A" Contract ID.

Now will you please help me to find out, How to find out pure not match result. if for any particular entry in column "A" and their all results are "Not Match " in column "B" against mentioned contract ID (whether its single or repeated ) in column "A" then result should be "Please verify". if contract IDs are repeated/single in column "A" (Please refer 5 and 6 entries)  and one result (CTR300- Match)  is "Match" and one result (CTR300- Not Match) is "Not Match" mentioned in column "B" then result should be "No need to verify". in column" C" i have added expected result.  same result formula should calculate. 

Again many Thanks for help and sorry for bothering you. However i need this. hence may i request for help.

Hello Amol,

Not sure how you get the Please verify result on all rows, as it works just fine for me.

Br,
Anders

Hi Mynda/ Anders

It worked !!. Thanks you very very much for your help. You guys are campion.

I will post my feedback on your Youtub cannel as well.  

Many Thanks, Amol