Auto put Yes/No/Both in nested table.

[Excelforum*ser_mH7]

If a table has 2 levels separated by row grouping and Level headings in 2 different columns.
How to put Yes in heading if there are all YESs under that level heading.
Or put all yes under a heading if yes is put infornt of that heading.
Pls see the attachment to understand better

[FDibbins]

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your problem n your posts for the searching benefit of all.

[Excelforum*ser_mH7]

Fixed it............

[FDibbins]

Thanks. Still a bit puzzled

Lets take row 2 as an example.

If there is an entry in all 3 cells = Yes
If only 2 cells are entered = ????
if only 1 cell is entered = ???
If no cells are entered = No

Please fill in the ??? and correct wherever necessary

[FDibbins]

Im thinking some variation on this will work for you...

	J	K	L	M
1	a	a	a	three

M1=IFERROR(CHOOSE(COUNTA(J1:L1),"One", "two", "three"), "None")
change as needed

[Excelforum*ser_mH7]

No not like that.
If all Yes/No(drop-down) is field is filled with Yes under a heading then the Yes/No field of that heading should turn Yes.If its all no then no.if both then Yes/No.If all are not filled then ???.
And the opposite also,if Yes if put in a heading's yes/no field then all things under the heading should turn Yes.

[FDibbins]

OK, so like this?

If all 3 have YES = Yes
If all 3 have NO = No
If only 2 cells have YES = ????
if only 1 cell has NO = ???
If only 2 cells have NO = ????
if only 1 cell has YES = ???
If no cells are entered = ???

[Excelforum*ser_mH7]

If all 3 have YES = Yes
If all 3 have NO = No
If only 2 cells have YES and 1 cell has No = Yes/No
if there is no entry yes/no field = ???
If there is only some entries fills but same options are selected = "the same entry'

And I want it to be 2-way
Below level affects above level(s) like explained above.
And heading affects sub levels like when yes is added to a heading then all sub levels under that heading should turn yes

[FDibbins]

Is this what you want?

	A	B	C	D
1	Yes	Yes	Yes	Yes
2	Yes	Yes	No	Yes/No
3	Yes	No	No	Yes/No
4	No	No	No	No
5				???

D1=IF(COUNTA(A1:C1)=0,"???",IF(COUNTIF(A1:C1,"yes")=3,"Yes",IF(COUNTIF(A1:C1,"no")=3,"No","Yes/No")))
copied down

[Excelforum*ser_mH7]

getting wrong output (see attachment)
ans how to do it other way (heading affects sub levels like when yes is added to a heading then all sub levels under that heading should turn yes )