Select Y in all 3 columns and return value

Solved/Closed
kk - Jan 6, 2010 at 09:16 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jan 7, 2010 at 08:41 PM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Jan 7, 2010 at 08:41 PM
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