ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to find out repeated data (https://www.excelbanter.com/excel-worksheet-functions/184273-how-find-out-repeated-data.html)

kingkingking

How to find out repeated data
 
Can anybody tell how we can find out any repeated data in the worksheet
easily and then delete it.



ryguy7272

How to find out repeated data
 
Several things come to mind... Can you try Data Sort (make sure you select
the entire sheet by clicking in the upper left hand corner of the sheet;
between the ! and the A). Hope that helps. If not, post back with more
information about what you need to do.

Regards,
Ryan---


--
RyGuy


"kingkingking" wrote:

Can anybody tell how we can find out any repeated data in the worksheet
easily and then delete it.




Gaurav[_2_]

How to find out repeated data
 
http://www.cpearson.com/excel/Duplicates.aspx


"kingkingking" wrote in message
...
Can anybody tell how we can find out any repeated data in the worksheet
easily and then delete it.




kingkingking

How to find out repeated data
 
I find it very useful
thanks
"Gaurav" . gbl...
http://www.cpearson.com/excel/Duplicates.aspx


"kingkingking" wrote in message
...
Can anybody tell how we can find out any repeated data in the worksheet
easily and then delete it.







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

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