| 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 |
| 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 | |||
Threaded Mode
