| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Multiple Criteria and Return values positioned above the zero
Hi Domenic,
Thank you ever so much for all your time and assistance. Your solution does provide me with the required results. Absolutely Brilliant! Cheers, Sam Domenic wrote: First, replace the formula for AB19 with the following... AB19, confirmed with CONTROL+SHIFT+ENTER, copied across and down: =IF(COLUMNS($AB19:AB19)<=$AA19,SMALL(IF(Array4=$A A$17+2,ROW(Array1)-MIN(R OW(Array1))+1),COLUMNS($AB19:AB19)),"") Then try... AA28: =SUM(AA19:AA25) AB28, confirmed with CONTROL+SHIFT+ENTER, and copied across: =IF(COLUMNS($AB28:AB28)<=$AA28,INDEX(Data,SMALL($ AB$19:$AK$25,COLUMNS($AB 28:AB28)),RIGHT(SMALL(IF($AB$19:$AK$25<"",$AB$19 :$AK$25*10^7+ROW($AB$19: $AK$25)-ROW($AB$19)+1),COLUMNS($AB28:AB28)),7))&","&$AA$17 ,"") -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
| Match Multiple Criteria & Return Numeric Labels across single row | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| match multiple criteria & return value from array | Excel Worksheet Functions | |||
Threaded Mode
