Need to compare 3 columns and return value

Question

Need to compare 3 columns and return value

[Closed]

Report

kk - Jan 3, 2010 at 10:25 PM
kk - Jan 5, 2010 at 12:06 AM

Hello,

I need write a macro
There are 3 columns in a sheet which has Y & N. If Y is found then it is should give comment in 4th column as No action required.
Please help

Need to compare 3 columns and return value
Compare 3 Columns excel ✓ - Forum - Excel
Select Y in all 3 columns and return value ✓ - Forum - Excel
How to compare two columns and return values from the third column in excel ✓ - Forum - Excel
Comparing columns and returning value ✓ - Forum - Excel
Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel

3 replies

Ask a question

hoot · Answer 1 · 2010-01-03T23:29:03-0500

Answer 1 / 3

hoot
Jan 3, 2010 at 11:29 PM

Hi. you can use the if formula

=IF(A2="N",IF(B2="N",IF(C2="N","","No Action Require"),"No Action Require"),"No Action Require")

hoot · Answer 2 · 2010-01-03T23:31:15-0500

Answer 2 / 3

hoot
Jan 3, 2010 at 11:31 PM

a b c comment
n n n
n y n No Action Require
y n n No Action Require
n n y No Action Require

kk · Answer 3 · 2010-01-05T00:06:28-0500

Answer 3 / 3

kk
Jan 5, 2010 at 12:06 AM

Can you please let me know how to write the same using the macro

Need to compare 3 columns and return value

3 replies

Your reply

Subscribe To Our Newsletter!