Select Y in all 3 columns and return value [Solved/Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
793
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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!