enthuguy
asked on
How to get populate a column with a string using excel formula
Hi EE,
could you help with attached sample excel and how to achieve this please?
Basically
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group have Yes, then Final column should have "Not Started".
3. If none of the group had Yes, e.g only -, then Final column should have "N/A"
4. Have populated mocked column (H) with expected value.
Thanks in advance
could you help with attached sample excel and how to achieve this please?
Basically
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group have Yes, then Final column should have "Not Started".
3. If none of the group had Yes, e.g only -, then Final column should have "N/A"
4. Have populated mocked column (H) with expected value.
Thanks in advance
Could you please provide us with a sample that includes the raw data and what you are expecting too see as the final output?
ASKER
HI Tusitala, thx for your quick reply to help me out.
sorry I just realized, I didnt click upload button to upload the document. anyway have uploaded both in xls and txt format.
thanks
sample_xls_grouped_column.xlsx
sample_xls_grouped_column.csv
sorry I just realized, I didnt click upload button to upload the document. anyway have uploaded both in xls and txt format.
thanks
sample_xls_grouped_column.xlsx
sample_xls_grouped_column.csv
Stick into G2 and copy down
=IF(COUNTIF(A2:F2,"Yes")> 0,"Not Started","NA")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much