I have just spent a few months typing the entire week by week uk top 40 music chart into excel.

I Have 4 Columns

A-B-C-D

A is the Artist Column
B is the Chart Number
C is the Year
D is the track title

Because the charts data changes every new chart i have data like this

A - B - C - D


En Vogue - 5 - 1990 - Hold On

En Vogue - 7 - 1990 - Hold On

En Vogue - 12 - 1990 - Hold On


Now what i would like to do is just to keep the lowest (highest chart number) number entry so

Out of the 3 entries above

this would be only one

En Vogue - 5 - 1990 - Hold On.


I am new to excel and the version i have is 2007 so any help is really appreciated.

Thankyou.


--
--------------------------------- --- -- -
Posted with NewsLeecher v4.0 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

(applies to xl2007 and probably xl2010)

Make a backup copy of the entire workbook.
Make another copy and store it on a CD or Flash drive.
Now make a copy of the sheet - hold down the Ctrl key and click and drag the sheet tab to the right.

On the copied sheet...
Select all of the data and sort by the Chart Number column - ascending.
Select all of the data
From the Ribbon Data tab choose "Remove Duplicates"
In the box displayed, remove the check mark from Column B (Chart Number)
Click OK.
'---
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(XL Companion add-in: compares, matches, counts, lists, finds, deletes...)




"CALM1"
wrote in message
b.com...
I have just spent a few months typing the entire week by week uk top 40 music chart into excel.

I Have 4 Columns

A-B-C-D

A is the Artist Column
B is the Chart Number
C is the Year
D is the track title

Because the charts data changes every new chart i have data like this

A - B - C - D
En Vogue - 5 - 1990 - Hold On

En Vogue - 7 - 1990 - Hold On

En Vogue - 12 - 1990 - Hold On

Now what i would like to do is just to keep the lowest (highest chart number) number entry so

Out of the 3 entries above

this would be only one

En Vogue - 5 - 1990 - Hold On.

I am new to excel and the version i have is 2007 so any help is really appreciated.
Thankyou.

Thankyou for the reply, i havent tried it yet but thanks for taking time out to reply.


--
--------------------------------- --- -- -
Posted with NewsLeecher v4.0 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Works Great , Thanks Once Again.


--
--------------------------------- --- -- -
Posted with NewsLeecher v4.0 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -