LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rk Rk is offline
external usenet poster
 
Posts: 18
Default Deleting Unique Values

Is there any way of tweaking this code so that the first instance of the
duplicates are
removed as well? IE: Display 2 duplicate cells even though there are 3
instances of the value

Thanks.

"מיכאל (מיקי) אבידן" wrote:

The code assumes the column is col. "A"
Micky


"RK" wrote:

How do you delete unique values in a column? I need to filter 7500+ rows to
only display duplicate values.

 
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
Deleting Unique Rows MWS Excel Discussion (Misc queries) 1 March 21st 06 09:37 PM
Deleting Duplicates, All records unique mirdonamy Excel Discussion (Misc queries) 7 January 11th 06 09:59 PM
deleting values in a worksheet without deleting the formulas patti Excel Worksheet Functions 1 October 28th 05 09:49 PM
Duplicates - deleting to get just unique ones koncept New Users to Excel 3 August 24th 05 06:41 PM
Count unique values and create list based on these values vipa2000 Excel Worksheet Functions 7 August 5th 05 01:17 AM


All times are GMT +1. The time now is 01:39 PM.

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

About Us

"It's about Microsoft Excel"