View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Any Help Appreciated

(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.