# Count unique item numbers

1. ## Count unique item numbers

Hello everyone, im very new to excel.
I want to create a function that registers the item number as the value of 1, and then it multiplies the number 1 with amount of pcs, so i can see how many of the different item numbers that have been sold this year. I cant really explain it in a different way, because im a totally noob to this program, and i just started in a new job and i need a system like this:D
So i was hoping some of you can take a look at this and maybe help me?

excel test.PNG

I am not actually selling PC, Macs or iPhones, its just an example
Thank you, best regards

2. ## Re: Count unique item numbers

Hello birgiir. Welcome to the forum.

Try in J3 and fill down.
Formula:
`Please Login or Register  to view this content.`

Edit I take your data to be all the same year. If they are mixed will need modified formula, and in that case an uploaded Excel file representative of what you are working with helps.

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Close window”
• click “Submit Reply”
The file name will appear at the bottom of your reply.

3. ## Re: Count unique item numbers

Hello.
I dont understand what you mean. Can you explain better please? As said im a total noob at this

4. ## Re: Count unique item numbers

Originally Posted by FlameRetired
Hello birgiir. Welcome to the forum.

Try in J3 and fill down.
Formula:
`Please Login or Register  to view this content.`
Hello.
I dont understand what you mean. Can you explain better please? As said im a total noob at this

5. ## Re: Count unique item numbers

Here, i think i managed to upload it.

6. ## Re: Count unique item numbers

Since the Item names have consistent Item numbers the simplest way with 1st / last of the year in H1:I1
Formula:
`Please Login or Register  to view this content.`
If the Item names need to reference the Item numbers this in row 7:9
Formula:
`Please Login or Register  to view this content.`

 A B C D E F G H I 1 1/1/2019 12/31/2019 2 Item name Item number Amount pcs Date: Total sale this year 3 PC 309123 50 12-Apr PC 65 4 Mac 309000 3 13-Apr Mac 15 5 iPhone 309555 5 25-Apr iPhone 25 6 Mac 309000 7 26-Apr 7 PC 309123 10 27-Apr PC 65 8 PC 309123 5 28-Apr Mac 15 9 Mac 309000 5 29-Apr iPhone 25 10 iPhone 309555 20 30-Apr 11 .. … . … 12 … … . . 13 . . . .

7. ## Re: Count unique item numbers

Originally Posted by birgiir
Hello.
I dont understand what you mean. Can you explain better please? As said im a total noob at this
Do you want me to explain the formula or instructions?

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1