Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
find value of a cell to the right a cell located with max()
row of data
4 colums col 1 a number col 2,"Boys" col 3 a number col 4 "Girls" Want to find the max() on the row and contents of the next cell, same row (ie: "Boys" or "Girls")... |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
find value of a cell to the right a cell located with max()
I assume that your data is look like this€¦
A (Col 1 ) B (Col 2) C (Col 3) D (Col 4) 20 Boys 12 Girls 16 Boys 20 Girls Now in E1 cell paste this formula =IF(A1C1,A1&" "&B1,C1&" "&D1) Copy the E1 cell formula and paste it to the remaining cells. Change the cell reference to your desired cell, if required. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "82716" wrote: row of data 4 colums col 1 a number col 2,"Boys" col 3 a number col 4 "Girls" Want to find the max() on the row and contents of the next cell, same row (ie: "Boys" or "Girls")... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
find value of a cell to the right a cell located with max()
If you have a lot of these kind of alternating* source data cols
to compare in rows 2/3 *num-textlabel-num-textlabel-num-textlabel-num-textlabel .... you could use this In say, A5: =INDEX(2:2,MATCH(MAX(2:2),2:2,0)+1) Copy down to A6 And to cover the possibility of ties in the maximums, you could use this in A5: =IF(COUNTIF(2:2,MAX(2:2))1,"1 Max",INDEX(2:2,MATCH(MAX(2:2),2:2,0)+1)) Adapt the ties trap return to suit: "1 Max" Success? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "82716" wrote: row of data 4 colums col 1 a number col 2,"Boys" col 3 a number col 4 "Girls" Want to find the max() on the row and contents of the next cell, same row (ie: "Boys" or "Girls")... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill dependent on drop down list located in different cell | Excel Discussion (Misc queries) | |||
Delete multiple rows where a blank cell is located | Excel Discussion (Misc queries) | |||
Utilizing a Cell even with a Formula located inside it | Excel Worksheet Functions | |||
Search in excel by date located in a cell | Excel Discussion (Misc queries) | |||
Can you dial a telephone number located in an cell? | Excel Discussion (Misc queries) |