Select Y in all 3 columns and return value

[Solved/Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

There are 3 columns where range is unknown for all the 3 columns( A, B & C). Macro need to selcect "Y" in all the 3 columns then No action else is should be blank

A B C D
Y Y Y No action
Y Y Y No action
Y N Y
Y N Y
Y N Y

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
open a helper column in D
in D2 paste this formula

=A2&B2&C2
copy D2 down

and then
in E2 type this formula

=IF(D2="yyy","no action","")

copy E2 down.

easy way of copying down -for e.g. D2 down
take the cursor to right bottom of D2 when cursor turns into +
double click that +
provided there are no blank data in the column previous.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month