to test, I simplified the formula to focus on 1 network with 4 sub-networks. the expected output is 4 different MAX values, one for each sub-network.
This is run within the tNetworkname table, so [Underground Network Name] Excel is removing the tNetworkName from that portion of the code. I find that irritating, but thats what Excel does.
In column [Underground Network Name] and in column tOrlando[City/Network] there are 4 sub-networks: Orlando - North, Orlando - South, Orlando - West, Orlando - East.
Only Orlando - North is reporting a value, but it is the wrong value. It is the Max for all sub-networks in the tOrlando[Group] column thus the Max(If is ignoring the criteria of [Underground Network Name] for the search.
edit to add: Current output is Orlando - North (wrong value), all others have a 0 as their output. All outputs are drastically off from the correct value.
1. Why is it ignoring the criteria value
2. How do I fix this?
Code:
=MAX(IF(tOrlando[City/Network] = [Underground Network Name], tOrlando[Group]))
This is run within the tNetworkname table, so [Underground Network Name] Excel is removing the tNetworkName from that portion of the code. I find that irritating, but thats what Excel does.
In column [Underground Network Name] and in column tOrlando[City/Network] there are 4 sub-networks: Orlando - North, Orlando - South, Orlando - West, Orlando - East.
Only Orlando - North is reporting a value, but it is the wrong value. It is the Max for all sub-networks in the tOrlando[Group] column thus the Max(If is ignoring the criteria of [Underground Network Name] for the search.
edit to add: Current output is Orlando - North (wrong value), all others have a 0 as their output. All outputs are drastically off from the correct value.
1. Why is it ignoring the criteria value
2. How do I fix this?