Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 15th 11, 07:32 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 3
Default 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
------------------- ----- ---- -- -


  #2   Report Post  
Old June 15th 11, 02:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
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.



  #3   Report Post  
Old June 17th 11, 06:47 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 3
Default 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
------------------- ----- ---- -- -

  #4   Report Post  
Old June 17th 11, 06:59 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 3
Default Any Help Appreciated

Works Great , Thanks Once Again.


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Your Help is Appreciated Sarah_Lecturer Charts and Charting in Excel 1 July 31st 09 07:08 PM
Help is much appreciated for- V Excel Discussion (Misc queries) 10 May 28th 09 12:16 AM
Help appreciated N.F[_2_] Excel Discussion (Misc queries) 0 August 17th 07 02:18 AM
Help would be much appreciated! Daptin Excel Worksheet Functions 2 November 24th 06 03:50 AM
Hello, again Help is appreciated Greegan Excel Worksheet Functions 0 December 17th 04 02:54 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017