ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleting Unique Values (https://www.excelbanter.com/excel-discussion-misc-queries/259082-deleting-unique-values.html)

Rk

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

מיכאל (מיקי) אבידן

Deleting Unique Values
 
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.


Rk

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.



All times are GMT +1. The time now is 04:12 AM.

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