Hi,
I need to find the adjacent cell of a min/max value and return it. However, I can't seem to make this work for my particular situation. I have two tables on separate tabs. One with all my data, and one I want to fill with specific data from the first table.
Table #1 structure example
<tbody>
</tbody>
I am using this formula to fill the Ht. columns on table #2 . It looks at "1 F Comm Ht." & "1 B Comm Ht." and puts the max value in "1 Highest Comm Ht."
=IF(MAX('Pole Data'!CU3,'Pole Data'!IA3)=0,"",MAX('Pole Data'!CU3,'Pole Data'!IA3))
I'm looking for a formula that will put the Owner of the max value in the adjacent cell called "1 Highest Comm Own."
table #2 structure example.
<tbody>
</tbody>
I need to find the adjacent cell of a min/max value and return it. However, I can't seem to make this work for my particular situation. I have two tables on separate tabs. One with all my data, and one I want to fill with specific data from the first table.
Table #1 structure example
ObjectID | 1 F Comm Own. | 1 F Comm Ht. | 2 F Comm Own. | 2 F Comm Ht. | other data | other data | other data | 1 B Comm Own. | 1 B Comm Ht. | 2 B Comm Own. | 2 B Comm Ht. | other data | other data |
1 | |||||||||||||
2 | |||||||||||||
3 | |||||||||||||
4 | |||||||||||||
5 | |||||||||||||
6 | |||||||||||||
7 | |||||||||||||
8 | |||||||||||||
9 | |||||||||||||
10 | |||||||||||||
ect... | |||||||||||||
<tbody>
</tbody>
I am using this formula to fill the Ht. columns on table #2 . It looks at "1 F Comm Ht." & "1 B Comm Ht." and puts the max value in "1 Highest Comm Ht."
=IF(MAX('Pole Data'!CU3,'Pole Data'!IA3)=0,"",MAX('Pole Data'!CU3,'Pole Data'!IA3))
I'm looking for a formula that will put the Owner of the max value in the adjacent cell called "1 Highest Comm Own."
table #2 structure example.
ObjectID | Highest MISC. Comm | 1 Highest Comm Own. | 1 Highest Comm Ht. | 2 Highest Comm Own. | 2 Highest Comm Ht. | other data | other data | other data | other data | other data | other data | other data |
1 | ||||||||||||
2 | ||||||||||||
3 | ||||||||||||
4 | ||||||||||||
5 | ||||||||||||
6 | ||||||||||||
7 | ||||||||||||
8 | ||||||||||||
9 | ||||||||||||
10 | ||||||||||||
ect... | ||||||||||||
<tbody>
</tbody>