Select Y in all 3 columns and return value
Solved/Closed
kk
-
Jan 6, 2010 at 09:16 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Select Y in all 3 columns and return value
- Vba select next empty cell in column - Guide
- Compare values in two columns and return the value from third ✓ - Forum - Excel
- Comparing columns and returning value ✓ - Forum - Excel
- Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel
- Comparing columns and returning value ✓ - Forum - Excel
1 reply
venkat1926
Jan 7, 2010 at 08:41 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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.
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.