用如下VBA程序,可在D6单元格得到所求结果: Sub maxstr() Dim rag As Range Dim maxb As Double Dim a$ maxb = Application.WorksheetFunction.Max(Range("B1:B" & Range("B65536").End(xlUp).Row)) a$ = "" For Each rag In Range("B1:B" & Range("B65536").End(xlUp).Row) If rag.Value = maxb Then If a$ = "" Then a$ = rag.Offset(, -1).Value Else a$ = a$ & " " & rag.Offset(, -1).Value End If End If Next Range("D6").Value = a$ End Sub