If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
returning a text value using a formula
There is probably an easy solution to this, but I can’t find it. Any help
would be appreciated. I have 3 columns. Each column has a heading with numbers in each one, and a total at the end of each one (totaling all of the column numbers together). I’ve set up a formula(MAX) that returns the highest number of the 3 columns. What I’d also like to do is have the heading for that highest number be returned in a cell next to the cell with the MAX formula. For example: Cells G3, J3, and M3 have the column headings (text) Cells G10, J10, and M10 have the “total” numbers Cell B13 has the MAX formula and the highest "total" number is returned here I’d like to have cell B14 show the corresponding heading for the number that shows up in B13 So, if cell J10 has the highest number (say 16) and has a J3 heading of “Par 4”, B13 will return 16 and B14 will return “Par 4” Any help you can provide would be appreciated! Kevin |
#2
|
|||
|
|||
returning a text value using a formula
This answer is based on the idea that there may be extraneous (unwanted)
values in H,I,K,L. in B14: ctrl+shift+enter: =INDEX(G3:M3,MATCH(G14,(N(MOD(COLUMN(G:M),3)=1)*G1 0:M10),0)) "KVSmith59" wrote: There is probably an easy solution to this, but I can’t find it. Any help would be appreciated. I have 3 columns. Each column has a heading with numbers in each one, and a total at the end of each one (totaling all of the column numbers together). I’ve set up a formula(MAX) that returns the highest number of the 3 columns. What I’d also like to do is have the heading for that highest number be returned in a cell next to the cell with the MAX formula. For example: Cells G3, J3, and M3 have the column headings (text) Cells G10, J10, and M10 have the “total” numbers Cell B13 has the MAX formula and the highest "total" number is returned here I’d like to have cell B14 show the corresponding heading for the number that shows up in B13 So, if cell J10 has the highest number (say 16) and has a J3 heading of “Par 4”, B13 will return 16 and B14 will return “Par 4” Any help you can provide would be appreciated! Kevin |
Thread Tools | |
Display Modes | |
|
|