Related:
- Select Y in all 3 columns and return value
- Vba select next empty cell in column - How-To - Excel
- 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
- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015
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.
Subscribe To Our Newsletter!
