+ Reply to Thread
Results 1 to 4 of 4

Forumula for delivering the highest value if there are several for a certain art no?

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    2

    Forumula for delivering the highest value if there are several for a certain art no?

    Hi!
    First time here.... I have a huge list of article numbers, first column. I need a formula to deliver the highest number for each art no, when there are several rows for the art, I am doing this manually now.... i.e. the third column, anyone knows how to do this?
    Sorry for not managing getting the columns in a structured way but I hope you understand what I mean.
    Thanks in advance...
    br Lotta

    Art No Number Highest number for each article no.
    40309304 6 6
    40309808 2 15
    40309808 2 15
    40310208 15 15
    40310468 48 48
    40310473 11 11
    40313443 30 34
    40313443 34 34
    40315178 43 44
    40315178 44 44
    40315178 24 44
    40315178 40 44
    40315178 40 44
    40315178 27 44
    40315178 27 44
    40315178 27 44
    40315178 23 44

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,939

    Re: Forumula for delivering the highest value if there are several for a certain art no?

    You can use this array* formula in cell C2:

    =MAX(IF($A$2:$A$18=A2,$B$2:$B$18))

    *Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual Enter.

    Then you can copy it down to the bottom of your data.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-11-2019
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    2

    Re: Forumula for delivering the highest value if there are several for a certain art no?

    Thanks for trying to help. Using the above formula makes me getting the highest value for the whole range, correct?
    What I need is the highest number per article number so for art no 4039304=6, for 40309808 it is 15, for 40315178 =44 etc. I have the A and B column above, it is the C column that I would like to generate (=highest number per art number)

    Should I maybe make a new column with the unique art numbers, then using VLOOKUP in combination with MAX? I cannot get this working.....
    Sorry if I am a bit slow...
    Thanks in advance!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,939

    Re: Forumula for delivering the highest value if there are several for a certain art no?

    See attached file, where I have put the formula in column E so you can easily compare the results with yours. Note the coloured cells - Article 40309808 is not the same as 40310208, so my results differ from yours for those cells.

    Hope this helps.

    Pete
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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