Ctrl+Shift+Enter doesn't work.
I check it on another PC - work.
Where is set-up Ctrl+Shift+Enter in Excel?


-----Original Message-----
=SUM(LARGE(IF(Sheet1!$A$1:$A$200=A1,Sheet1!$B$1:$ B$200),
{1,2}))

Entered in B1 on the second sheet using Ctrl+Shift+Enter
Rather than just
enter. (since this is an array formula) Then drag fill
down the column

Adjust the reference to rows 1 to 200 to match your data.

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
Hi,

I have data in column:

Kolumn1 Kolumn2

name1 5,5
name2 6,3
name1 7,9
name1 8,4
name1 3,2
name1 9,9
name2 1,2
name2 2,2
name3....etc.(a few thousand records)

How make choice in VBA data in Kolumn1?
Result operation:
(in another sheet)
Kolumn1 Kolumn2
name1 .... (sum = 2 largest data of name1 in
kolumn2)
name2 .... (sum = 2 largest data of name2 in
kolumn2)
name3 .... (sum = 2 largest data of name3 in
kolumn2)
etc....

Thanks for any help

Regards
Mark








.