Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Find repeted data???
Hi All,
in excel how to find the repeted data i mean to say i have few names like this in a column... fhacsarp.p fhardarp.p fhargrrp.p fharigrp.p fhbkdcrp.p fharsgrp.p fhartnrp.p fharttrp.p fhbkcorp.p fhbkdcrp.p fhbkdurp.p i even have repeted name how do i find out the repeted name..... |
#2
|
|||
|
|||
Hi!
Here's one way: Assume your data is in column A, starting in A1. In B1 enter this formula and copy down as far as the list in column A: =IF(COUNTIF(A$1:A$11,A1)=1,"",COUNTIF(A$1:A$11,A1) ) Biff -----Original Message----- Hi All, in excel how to find the repeted data i mean to say i have few names like this in a column... fhacsarp.p fhardarp.p fhargrrp.p fharigrp.p fhbkdcrp.p fharsgrp.p fhartnrp.p fharttrp.p fhbkcorp.p fhbkdcrp.p fhbkdurp.p i even have repeted name how do i find out the repeted name..... . |
#3
|
|||
|
|||
Thanks Bif
"Biff" wrote: Hi! Here's one way: Assume your data is in column A, starting in A1. In B1 enter this formula and copy down as far as the list in column A: =IF(COUNTIF(A$1:A$11,A1)=1,"",COUNTIF(A$1:A$11,A1) ) Biff -----Original Message----- Hi All, in excel how to find the repeted data i mean to say i have few names like this in a column... fhacsarp.p fhardarp.p fhargrrp.p fharigrp.p fhbkdcrp.p fharsgrp.p fhartnrp.p fharttrp.p fhbkcorp.p fhbkdcrp.p fhbkdurp.p i even have repeted name how do i find out the repeted name..... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |