Max of 1 column for each unique entry in another column

[Guest]

I have a code complexity spreadsheet. Each entry has the module name, file
name, complexity number of the module. I want to filter the module with the
maximum complexity for each unique file name (displaying the entire line). I
am kind of new to Excel, so I am not sure how to do this. Any help is highly
appreciated.

I think this falls under Excel programming. If it is a different group,
please direct me. thanks.

 

[Bernie Deitrick]

Arun,

Use another column (let's say column D), with an array formula (entered with
ctrl-shift-enter) like

=MAX(IF($A$2:$A$1000=A2,$C$2:$C$100))=C2

Where Filenames are in column A, and the complexity numbers are in column C.
Note that this will not work if the complexity numbers are 'multi-decimal'
1.2.3.01

Copy that formula down, then filter based on column D, to show TRUE values.

HTH,
Bernie
MS Excel MVP