|
What's causing error message?
Hello all,
The formula: =ADDRESS(2,MATCH(MAX(B2:AY2),A2:AY2,0),4) returns the cell address (G2) of the largest number in B2:AY2 correctly. The formula: =OFFSET(G2,-1,0) returns the name of the team in G1 that has that highest total. So why, when I replace the "G2" in the OFFSET formula with the ADDRESS formula: =OFFSET(ADDRESS(2,MATCH(MAX(B2:AY2),A2:AY2,0),4),-1,0) do I get an error message? Thanks for any ideas. -- Jim T |
What's causing error message?
Sorry, posted in the wrong area. Have reposted in Worksheet Functions.
-- Jim T "Jim Tibbetts" wrote: Hello all, The formula: =ADDRESS(2,MATCH(MAX(B2:AY2),A2:AY2,0),4) returns the cell address (G2) of the largest number in B2:AY2 correctly. The formula: =OFFSET(G2,-1,0) returns the name of the team in G1 that has that highest total. So why, when I replace the "G2" in the OFFSET formula with the ADDRESS formula: =OFFSET(ADDRESS(2,MATCH(MAX(B2:AY2),A2:AY2,0),4),-1,0) do I get an error message? Thanks for any ideas. -- Jim T |
| All times are GMT +1. The time now is 08:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com