Help with MAX and filtered formula

LlebKcir

Board Regular
Joined
Oct 8, 2018
Messages
206
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:

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

generates #VALUE error:

Code:
=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.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,463
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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

Board Regular
Joined
Oct 8, 2018
Messages
206
Fantastic, thank you RoryA. Now onto the next part of building my filter :D. how to address sub-networks. That will be another thread.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,613
Messages
5,625,848
Members
416,139
Latest member
MattBoard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top