| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to display heading of column corresponding to the cell
i have a row E20-I20 where months January to May are displayed respective. i also have row E21-I21 to display the amount corresponding to the month. i have a cell E23 which is used to display the highest amount from row E21-I21. how do i display the month corresponding to it?? ex: E20 has the value January and E21 has the value 200. -- angelrain ------------------------------------------------------------------------ angelrain's Profile: http://www.excelforum.com/member.php...o&userid=15990 View this thread: http://www.excelforum.com/showthread...hreadid=274571 |
|
#2
|
|||
|
|||
|
Hi
=INDEX(E20:I20,MATCH(E23,E21:I21,0)) -- Regards Frank Kabel Frankfurt, Germany "angelrain" schrieb im Newsbeitrag ... i have a row E20-I20 where months January to May are displayed respective. i also have row E21-I21 to display the amount corresponding to the month. i have a cell E23 which is used to display the highest amount from row E21-I21. how do i display the month corresponding to it?? ex: E20 has the value January and E21 has the value 200. -- angelrain --------------------------------------------------------------------- --- angelrain's Profile: http://www.excelforum.com/member.php...o&userid=15990 View this thread: http://www.excelforum.com/showthread...hreadid=274571 |
|
#3
|
|||
|
|||
|
Try this in E24:
=INDEX(E20:I20,MATCH(MAX(E21:I21),E21:I21,0)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "angelrain" wrote in message ... i have a row E20-I20 where months January to May are displayed respective. i also have row E21-I21 to display the amount corresponding to the month. i have a cell E23 which is used to display the highest amount from row E21-I21. how do i display the month corresponding to it?? ex: E20 has the value January and E21 has the value 200. -- angelrain ------------------------------------------------------------------------ angelrain's Profile: http://www.excelforum.com/member.php...o&userid=15990 View this thread: http://www.excelforum.com/showthread...hreadid=274571 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| Display cell value on a chart. | Charts and Charting in Excel | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
| How to populate column with formula based on value in cell | Excel Worksheet Functions | |||
Linear Mode
