Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
neda5
 
Posts: n/a
Default excluding repeating values

I have a column wuth date and some entries are repeating. I want to copy that
data to another column, but do not want to copy duplicate values ( I want to
exclude repeating values when copying and pasting). Is there an option to do
that?
Thanks. Neda
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Take a look at

http://contextures.com/xladvfilter01.html#FilterUR


In article ,
"neda5" wrote:

I have a column wuth date and some entries are repeating. I want to copy that
data to another column, but do not want to copy duplicate values ( I want to
exclude repeating values when copying and pasting). Is there an option to do
that?
Thanks. Neda

  #3   Report Post  
neda5
 
Posts: n/a
Default

Thanks. Worked fine. Neda

"JE McGimpsey" wrote:

Take a look at

http://contextures.com/xladvfilter01.html#FilterUR


In article ,
"neda5" wrote:

I have a column wuth date and some entries are repeating. I want to copy that
data to another column, but do not want to copy duplicate values ( I want to
exclude repeating values when copying and pasting). Is there an option to do
that?
Thanks. Neda


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
Zero values in a log chart Joelle_Smith Charts and Charting in Excel 2 May 8th 23 03:42 AM
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
Combine FREQUENCY and SUM of Associated Values MichaelC Excel Worksheet Functions 3 July 3rd 05 01:54 AM
Return Consecutive Values - Pairs Sam via OfficeKB.com Excel Worksheet Functions 6 July 2nd 05 04:43 PM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 02:04 AM


All times are GMT +1. The time now is 02:07 PM.

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

About Us

"It's about Microsoft Excel"