Naming the Header of table based on Grouping & ungrouping

[Nandakumar]

Hi,

I need a help with a formula on the header of the table,if table is grouped header name should be "Group",if ungrouped it should be "Subdivision"
For example,

In attached sheet when i ungroup the table B5 should be named as "Subdivision"
If i group the table B5 should be named as "Group"

 

[Villalobos]

Hi,

Is this what you are looking for?

 

[Nandakumar]

Thanks
THis is correct.
But if table is 20 groups means formula will be very big?
Let say Group will be till A,B....Z

 

[Luke M]

Need a formula that can detect if a row is hidden. In A6:A11, put this formula:
=SUBTOTAL(103,B6)

Change font color to white, if desired.

Then, formula in B5 becomes:
=IF(COUNTIF(A6:A11,0),"Group","Subdivision")

 

[Nandakumar]

Thank you so much LUKE and Villalobos.

It works.