Understanding the formula

[ExcelRoy]

Hi,

I have the following formula I am trying to understand

=IF(IF(ROWS($EC$16:EC16)>$EO$14,"",INDEX($DU$16:$DU$512,MATCH(ROWS($EC$16:EC16),$EO$16:$EO$512,0)))=0,"",IF(ROWS($EC$16:EC16)>$EO$14,"",INDEX($DU$16:$DU$512,MATCH(ROWS($EC$16:EC16),$EO$16:$EO$512,0))))

the $DU$16:$DU$512 part is what is being returned, but I am struggling to understand the $EC$16:EC16 part ?

Many thanks for any help

 

[ExcelRoy]

Columns EP:FE is what I am trying to work out

I need a list of outstanding parts in EP:FE but if Category C is "Stock" its not to be listed even if its outstanding

Thanks

 

[Matty]

It looks as though EP16:FF512 is returning a filtered list from the main table. What is the basis for the filtering?

Matty

 

[ExcelRoy]

Hi Matty,

sorry for the late reply

I have a macro that copies the filtered range and pastes into another workbook to generate reports

Unfortunately copying the complete range would cause too many complications

Thanks