Posted to microsoft.public.excel.worksheet.functions
|
|
Returning Numeric Results across a Single Row in Consecutive Cells
Hi Domenic,
Thank you for assistance. The Formula works Great!
Cheers,
Sam
Domenic wrote:
Here's another way...
Assuming that the results are to be returned in Row 25, starting at D25,
leave C25 empty, then try the following formula which needs to be
confirmed with CONTROL+SHIFT+ENTER...
=INDEX($D3:$BZ3,MATCH(0,IF(COUNTIF($D6:$BZ6,$D3:$ BZ3)=0,IF(COUNTIF($D16:$
BZ16,$D3:$BZ3)=0,COUNTIF($C25:C25,$D3:$BZ3))),0 ))
Note that Conditional Formatting can be used to hide #N/A error values.
Hope this helps!
Hi All,
[quoted text clipped - 20 lines]
Thanks
Sam
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200607/1
|