Duplicate Data

[l KAUTION l]

I have data like the following:

A B C
1 John West 11 14
2 John West 12 16
3 John West 10 11
4 Tom East 8 11
5 Tom East 9 10
6 Jim North 4 9
7 Tim South 5 7

I need to remove the duplicated names in column A, I also need the min number in column B and the max number in column C that match the names in column A.

Such as:

A B C
1 John West 10 16
2 Tom East 8 11
3 Jim North 4 9
4 Tim South 5 7

If I need to provide more information, I can try.
Thanks in advance!!

 

[acw]

Hi

Put the data above in the range A2:C8, put a heading in A1, then use data, filter, advanced filter, on the range A1:A8 to extract a unique list of the names to the range G1.

Then in H2 array enter (ctrl, shift, enter) the formula
=MIN(IF($A$2:$A$8=G2,$B$2:$B$8,""))

I2 array enter
=MAX(IF($A$2:$A$8=G2,$C$2:$C$8,""))

Copy down as required.

Tony

 

[l KAUTION l]

Thanks for the reply acw! This does seem to work however is there anyway this could be done with a formula of some type? I will need to do this on a weekly basis and the less manual the better. Also for some reason if the name appears 3 times it returns 2 names.

Example of what happens:
Name
Bob
Bob
Bob
Tom
Tom
Tim
Ron

Would be returned as:

Name
Bob
Bob
Tom
Tim
Ron

 

[l KAUTION l]

I resorted to Access and retrieved the information that I needed.
Also I redid the advanced autofilter step and it did eliminate all duplicates. Not sure why it didn't the first time though