Help with MAX and filtered formula

[LlebKcir]

Thank you, I have the following formula that will generate the correct table name of tNetwork, but when I attempt to wrap that in a MAX&"[Group]" I get a #VALUE error:

working to generate tNetwork:

=IFERROR("t"&LEFT(tNetworkName[Underground Network Name],FIND(" ",tNetworkName[Underground Network Name])-1),"t"&(tNetworkName[Underground Network Name]))

generates #VALUE error:

=MAX(IFERROR("t"&LEFT(tNetworkName[Underground Network Name],FIND(" ",tNetworkName[Underground Network Name])-1),"t"&(tNetworkName[Underground Network Name]))&"[Group]")

Some of the network names are single words, think Atlanta, or Troy, while others are two words, think Saint Louis.

The working code will generate the tNetwork (tAtlanta, or tSaint) as desired, but as soon as I attempt to wrap the MAX command it blows up in my face. My lack of knowledge is the issue :D...

Some help and direct guidance will be greatly appreciated.

 

[RoryA]

You can't directly use text as a reference, you have to wrap it in an INDIRECT functions:

=MAX(INDIRECT(IFERROR("t"&LEFT(tNetworkName[Underground Network Name],FIND(" ",tNetworkName[Underground Network Name])-1),"t"&(tNetworkName[Underground Network Name]))&"[Group]"))

 

[LlebKcir]

Fantastic, thank you RoryA. Now onto the next part of building my filter :D. how to address sub-networks. That will be another thread.