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

1. ## 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.
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. ## 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. ## 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...

4. ## 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

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