4 Columns compare

[pmeghnathi]

How do this formula in excel
A1=as b1=cd C1=as D1=cd
Result true'

A1=as b1=cd C1=as D1=a
Result fauls

 

[pmeghnathi]

That is not what your profile shows.

View attachment 97471

Note how the formula must be entered as shown under all my mini sheets.

View attachment 97472

Sorry my profile changed office version 2003.
Where's mini sheet.plz send

 

[Peter_SSs]

Where's mini sheet.plz send

I have posted several. The last one was in post #27

 

[pmeghnathi]

I have posted several. The last one was in post #27

I was many try but not your formula work in excel 2003 and 2016.
Plz. Solutions for excel 2003

 

[Peter_SSs]

The formula should work in those earlier versions. Did you confirm the formula with Ctrl+Shift+Enter, not just Enter as I highlighted in my last post?

 

[pmeghnathi]

The formula should work in those earlier versions. Did you confirm the formula with Ctrl+Shift+Enter, not just Enter as I highlighted in my last post?

Many many thanks good work.thanks for help

 

[Peter_SSs]

You're welcome.

 

[Peter_SSs]

@pmeghnathi
Please mark the actual post that contains the answer to your question, not your feedback comment as this would help future readers. I have removed the 'Mark as solution' from post #35 since it clearly does not contain the solution to your thread.