count the production result and making the date in text format

[Biff]

Hi aboiy,

You can use a formula like this to get the qty:

=SUMPRODUCT((Sheet1!B79="BD306")*1)

How you get all the design codes in a verticle column
without repeats will take some work!

Biff

 

[aboiy]

Biff,

Thank you so much.

Do you have any comments on my second question?

the month to appear only as 'October,2003'
basing on =today() or =now().

aboiy

 

[Paul]

Biff,

Thank you so much.

Do you have any comments on my second question?

the month to appear only as 'October,2003'
basing on =today() or =now().

aboiy

Put =TODAY() in the cell and format it as mmmm,yyyy

 

[Peo Sjoblom]

Format>cells>number and custom

mmmm, yyyy

 

[Guest]

Paul & Peo,

Thank you to both of you, again its an additional
knowledge to me.


aboiy