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