Link to home
Start Free TrialLog in
Avatar of enthuguy
enthuguyFlag for Australia

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
Avatar of Tusitala
Tusitala

Could you please provide us with a sample that includes the raw data and what you are expecting too see as the final output?
Avatar of enthuguy

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
Avatar of Shaun Vermaak
Stick into G2 and copy down
=IF(COUNTIF(A2:F2,"Yes")> 0,"Not Started","NA")

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks very much