+ Reply to Thread
Results 1 to 7 of 7

Count unique item numbers

  1. #1
    Registered User
    Join Date
    01-10-2019
    Location
    Norge
    MS-Off Ver
    2016
    Posts
    4

    Exclamation 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
    Last edited by 6StringJazzer; 01-10-2019 at 06:11 PM. Reason: Changed title from "Need help i am a beginner"

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,614

    Re: Count unique item numbers

    Hello birgiir. Welcome to the forum.

    Try in J3 and fill down.
    Formula: copy to clipboard
    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 “Upload”
    • click “Close window”
    • click “Submit Reply”
    The file name will appear at the bottom of your reply.
    Last edited by FlameRetired; 01-10-2019 at 06:33 PM.
    Dave

  3. #3
    Registered User
    Join Date
    01-10-2019
    Location
    Norge
    MS-Off Ver
    2016
    Posts
    4

    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. #4
    Registered User
    Join Date
    01-10-2019
    Location
    Norge
    MS-Off Ver
    2016
    Posts
    4

    Re: Count unique item numbers

    Quote Originally Posted by FlameRetired View Post
    Hello birgiir. Welcome to the forum.

    Try in J3 and fill down.
    Formula: copy to clipboard
    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. #5
    Registered User
    Join Date
    01-10-2019
    Location
    Norge
    MS-Off Ver
    2016
    Posts
    4

    Re: Count unique item numbers

    Here, i think i managed to upload it.
    Attached Files Attached Files

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,614

    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: copy to clipboard
    Please Login or Register  to view this content.
    If the Item names need to reference the Item numbers this in row 7:9
    Formula: copy to clipboard
    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. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,614

    Re: Count unique item numbers

    Quote Originally Posted by birgiir View Post
    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Beginner
    By SolArch in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-12-2016, 11:16 AM
  2. Beginner at VBA
    By lianne.cuscani in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-30-2015, 03:24 PM
  3. i am a beginner
    By saeedpak13 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-25-2014, 08:42 AM
  4. Hello, Beginner Here
    By mendoza1964 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-17-2012, 07:23 PM
  5. Help please for a beginner
    By LACKLUSTABUSTA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2010, 06:41 AM
  6. Help for a beginner?
    By TimD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2009, 06:58 PM
  7. Beginner
    By Mardikas09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2009, 05:59 AM

Bookmarks

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