| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Repeated Data?
I have a column of numbers such as:
190.000 190.000 194.000 580.000 910.000 910.111 910.130 I want to delete the numbers that are repeated. What is the best way to accomplish this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete Repeated Data?
If you have your numbers in Col A then enter this formula in B1 and copy down
till end of your data set.. =IF(COUNTIF($A$1:A1,A1)=1,A1,"") It will replace duplicate numbers with blank except for the first occurence. "evoxfan" wrote: I have a column of numbers such as: 190.000 190.000 194.000 580.000 910.000 910.111 910.130 I want to delete the numbers that are repeated. What is the best way to accomplish this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete Repeated Data?
I must be doing something wrong.
This is the formula I entered. =IF(COUNTIF($R$6:R533,R6)=1,R6,"") The result is a blank; it does not show the first occurrence. How can I correct? "Sheeloo" wrote: If you have your numbers in Col A then enter this formula in B1 and copy down till end of your data set.. =IF(COUNTIF($A$1:A1,A1)=1,A1,"") It will replace duplicate numbers with blank except for the first occurence. "evoxfan" wrote: I have a column of numbers such as: 190.000 190.000 194.000 580.000 910.000 910.111 910.130 I want to delete the numbers that are repeated. What is the best way to accomplish this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete Repeated Data?
Use
=IF(COUNTIF($R$6:R6,R6)=1,R6,"") and copy down till R533 (when you copy down R6 will change to R7, R8 and so on) For the current row, it counts the number of times the value in Col B for that Row occurs from R6 till current row, and replaces it with "" if the count is more than 1. "evoxfan" wrote: I must be doing something wrong. This is the formula I entered. =IF(COUNTIF($R$6:R533,R6)=1,R6,"") The result is a blank; it does not show the first occurrence. How can I correct? "Sheeloo" wrote: If you have your numbers in Col A then enter this formula in B1 and copy down till end of your data set.. =IF(COUNTIF($A$1:A1,A1)=1,A1,"") It will replace duplicate numbers with blank except for the first occurence. "evoxfan" wrote: I have a column of numbers such as: 190.000 190.000 194.000 580.000 910.000 910.111 910.130 I want to delete the numbers that are repeated. What is the best way to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete in row C if it is repeated in row D | Excel Worksheet Functions | |||
| delete repeated data in excel | Excel Discussion (Misc queries) | |||
| Delete repeated Cells | Excel Worksheet Functions | |||
| delete repeated numbers | Excel Worksheet Functions | |||
| Delete repeated numbers in Excel | Excel Worksheet Functions | |||
Linear Mode
