ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Any Help Appreciated (https://www.excelbanter.com/excel-worksheet-functions/270834-any-help-appreciated.html)

CALM1

Any Help Appreciated
 
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
------------------- ----- ---- -- -


Jim Cone[_2_]

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.




CALM1

Any Help Appreciated
 
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
------------------- ----- ---- -- -


CALM1

Any Help Appreciated
 
Works Great , Thanks Once Again.


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



All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com