On Friday, December 29, 2017 at 7:09:07 AM UTC-8, Claus Busch wrote:
Hi Howard,

Am Fri, 29 Dec 2017 07:07:17 -0800 (PST) schrieb L. Howard:

This is a worksheet formula, right? I forget what Talelle1 should be on my sheet.
=OFFSET(Tabelle1!$C$2,,,MATCH("",Tabelle1!$C:$C, 0)-2)

change Tabelle1 to Sheet1


Regards
Claus B.
--

Hi Claus,

On my sheet this returns #NAME?
=OFFSET(Cable Lists!$C$2,,,MATCH("",Cable Lists!$C:$C,0)-2)

These both work on the sheet.
=COUNTA(Cable_1)-COUNTBLANK(Cable_1)
=COUNTIF(C2:C100,"?*")

I could probably use the COUNTIF in the code for my Item Count.

Howard