Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
Ok here's what I got: A. I have cells: D40, G40, J40, M40, P40, S40, V40, Y40, AB40, AE40, which have varius numbers in them. B. I have cells: D34, G34, J34, M34, P34, S34, V34, Y34, AB34, AE34, which have varius names in them. In cell G53 I need a formula that finds the MAX for D40, G40, M40 and so on Let's say the max is 3, then search cells D34, G34, J34 and so on and if that cell has a 3 display the name. This is the formula I have: =INDEX($D$34:$AS$34,MATCH(MAX(D40:AS40),D40:AS40,0 )) Only problem is if there are multiple answers, it only displays the first cell that is true. In my formula D34, M34 and S34 all equal 3, but cell G53 just shows D34. Can someone help? Thanks -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
Here's a sample +-------------------------------------------------------------------+ |Filename: web2.doc | |Download: http://www.excelforum.com/attachment.php?postid=4743 | +-------------------------------------------------------------------+ -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
Hi!
It would be easier to work with a xls file. Can you post an xls file? Biff "fastballfreddy" <fastballfreddy.27lply_1147280405.7168@excelforu m-nospam.com wrote in message news:fastballfreddy.27lply_1147280405.7168@excelfo rum-nospam.com... Here's a sample +-------------------------------------------------------------------+ |Filename: web2.doc | |Download: http://www.excelforum.com/attachment.php?postid=4743 | +-------------------------------------------------------------------+ -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
I tried, but it says invalid file. Here's a link where it is posted http://www.ozgrid.com/forum/showthre...d=1#post257435 -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
Can't open the ozgrid link unless you're a member!
You can upload to excelforum if you zip the file. Basically, what you want to do will require that you return multiple values to multiple cells. Not really difficult but I just would like to see where to put these multiple results. Biff "fastballfreddy" <fastballfreddy.27lsdz_1147284003.8483@excelforu m-nospam.com wrote in message news:fastballfreddy.27lsdz_1147284003.8483@excelfo rum-nospam.com... I tried, but it says invalid file. Here's a link where it is posted http://www.ozgrid.com/forum/showthre...d=1#post257435 -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
Here you go +-------------------------------------------------------------------+ |Filename: web.zip | |Download: http://www.excelforum.com/attachment.php?postid=4746 | +-------------------------------------------------------------------+ -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
Ah man, merged cells! buzz kill!
The merged cells will make this a nightmare! If you want this to work you need to redesign and NOT USE MERGED CELLS. Biff "fastballfreddy" <fastballfreddy.27m7fm_1147303503.6782@excelforu m-nospam.com wrote in message news:fastballfreddy.27m7fm_1147303503.6782@excelfo rum-nospam.com... Here you go +-------------------------------------------------------------------+ |Filename: web.zip | |Download: http://www.excelforum.com/attachment.php?postid=4746 | +-------------------------------------------------------------------+ -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
Ok, I can undo the merged cells, but what would I use for a formula? Let's just say the names are in A1-A10, the #s in B1-B10. What formula would you use in C1? thanks -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH w/ multiple answers?
I put together a little sample file that demonstrates this.
Send me an email: xl can help at comcast period net Remove "can" and change the obvious. This requires an array formula and you can't enter array formulas in merged cells. Merged cells really don't do anything but cause problems! Biff "fastballfreddy" <fastballfreddy.27ml3a_1147321202.2769@excelforu m-nospam.com wrote in message news:fastballfreddy.27ml3a_1147321202.2769@excelfo rum-nospam.com... Ok, I can undo the merged cells, but what would I use for a formula? Let's just say the names are in A1-A10, the #s in B1-B10. What formula would you use in C1? thanks -- fastballfreddy ------------------------------------------------------------------------ fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986 View this thread: http://www.excelforum.com/showthread...hreadid=540574 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple column match per row | Excel Discussion (Misc queries) | |||
Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
match multiple criteria and highlight corresponding row in Excel | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) |