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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

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,407
Messages
5,624,587
Members
416,036
Latest member
eloisa manzanarez

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