| 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) | |||
Linear Mode
