Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move one cell up from result cell
I have a sheet that has total monies at the end of every month. The Month's (January, February, March, etc...) are in row 192 whereas the totals for the months are right below them in row 193. I figured out how to find the lowest of all the totals by placing the following in a cell. Code: -------------------- =MIN(B193:AI193) -------------------- The problem is that I want to know the corresponding month for that value, how would I go about doing that? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=498931 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move one cell up from result cell
=INDEX(B192:AI192,MATCH(MIN(B193:AI193),B193:AI193 ,0))
-- Regards, Peo Sjoblom (No private emails please) "DKY" wrote in message ... I have a sheet that has total monies at the end of every month. The Month's (January, February, March, etc...) are in row 192 whereas the totals for the months are right below them in row 193. I figured out how to find the lowest of all the totals by placing the following in a cell. Code: -------------------- =MIN(B193:AI193) -------------------- The problem is that I want to know the corresponding month for that value, how would I go about doing that? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=498931 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move one cell up from result cell
Thanks, it looks simple yet complex. Whatever its worth though, it works beautifully. Thanks again -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=498931 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
How do I move the current cell to the top of the screen? | Excel Discussion (Misc queries) | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |