| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Return Numeric Label based on (Numeric Value) Criterion
Hi Domenic,
Brilliant! Thank you very much. Cheers, Sam Domenic wrote: Based on your sample data, try the following... P117: =SUM(IF(MOD(ROW(F118:N133)-ROW(F118),3)=0,IF(F118:N133=50,1))) ...confirmed with CONTROL+SHIFT+ENTER Q117, copied down: =IF(ROWS(Q$117:Q117)<=P$117,SMALL(IF(MOD(ROW(F$11 8:N$133)-ROW(F$118),3)=0 ,IF(F$118:N$133=50,F$117:N$132)),ROWS(Q$117:Q117) ),"") ...also confirmed with CONTROL+SHIFT+ENTER. Hope this helps! -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
| Find Multiple instances of Single Criterion in Row & Return To a Single Col | Excel Worksheet Functions | |||
| Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Threaded Mode
