count value with filter...

S

sal21

my file: http://www.mytempdir.com/941009

with a macro...

in GAF sheet column H with data.
In sheet Corporate, Retail_Poe ecc... have a column G with other data.

I want count how many value are present in column H of GAF refered column G
of CORPORATE and store in a variable named CORPORATE...

I want count how many value are present in column H of GAF refered column G
of RETAIL_POE and store in a variable named RETAIL_POE...

ecc...

The rest of value in GAF not finded store in a vaiable OTHER....

tks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top