Add highest values with the same basis

Dear all,

I have a very delicious issue! Please see attached Excel screenshot. I need to find the two highest values, but that would be too easy at this stage. Insofar, I need to find the two highest values with the same basis. Here is the difference, what I mean:

The two highest values are: 35.00 (Porsche) and 40.00 (Audi) = Result 75.00 – but this is not what I am looking for…
The two highest values with the same basis: 40.00 (Audi) and 30.00 (Audi) = Result 70.00 – this is what I want…!!!

Now, to make the issue a little bit more difficult, it is not permitted to use an additional column for extra calculations, nor to use the words "Porsche", "Audi", etc. (because these parameters are finally unknown).

So it should be a pure formula, e.g. =SUMPRODUCT(LARGE(B2:B11;ROW(1:2))*1)BUT(WITH SAME BASIS AS IN COLUMN A)

Many thanks for your efforts on this.

Best regards,
FixandFoxi (yes, I am)

Basically yes, it is important that they have the same basis. In the final version, I have to find "the 10 highest values" out of 10'000 entries...

In helper column you can write:

=SUM(LARGE(IF($A$2:$A$100=$A2;$B$2:$B$100);{1;2}))
(comfirmed with ctrl+shift+enter)

And then use MAX value from this column

@ zbor: thanks for this, but any chance to do this without any helper column?
@ Soren: quite sure...

Hi Marcol

Interesting approach... will try this on the large file! Can you please give me some additional information iro "REPT("Z";255);CHOOSE({1;2}"... I do not understand this term. Why? Thanks!

Hi daddylonglegs, can you please upload the Excel sheet with the formula, I can not use the above one, seems to be an error somewhere (yes, I finalised with CTRL+SHIFT+ENTER :-)! Thanks!

Special thanks to all of you (especially Marcol and daddylonglegs, they gave me the final solution/approach)! Simply brilliant...