Excel: Deleting Repeating Numbers In A Column?

Question

I have 100,000 numbers in Column C. I need help because typically there are numerous numbers that are the identical -- I need to have it so there is only one set of each number. That said, can someone help me with making a function or Macro to (whichever is quicker!) to make it so repeat numbers get deleted and then its entire row is deleted.

Please remember that sorting and filtering the numbers (to see duplicates) could not work as it would be way too many numbers to sort thru,.

Answer 1

You have these options:

AUTOMATICALLY

Use this macro: http://excel.tips.net/Pages/T002109_Removing_Duplicate_Cells.html



MANUALLY

• Select the range of cells/column

• Choose the DATA tab and from the DATA TOOLS group select REMOVE DUPLICATES.

• From the options show choose the ones that applies to you

Example:

• Click REMOVE DUPLICATES

• Check-mark the box corresponding to the column containing the duplicates you want removed

• Click OK

That's all

Answer 2

You can data sort 100,000 numbers. Highlight the table, Data, Sort, decide on whether there is a header row and sort it. Then in like D2, do a

=IF(C1=C2,1,0)

Select that cell and the rest below it and do a control d to copy the formula down then select all those cells and do a Copy then do a Paste Special on the same area or column E and paste just the value, that way the zeros and ones will be there instead of the formula. Select the whole table and sort by column E and all the 1s will be together for deletion.

Answer 3

have you tried the Remove Duplicates button?



1. Select column C

2. Click the Data tab, then click the Remove Duplicates button

3. Click OK



Or this



Sub Macro1()

LastRow = Range("C" & Rows.Count).End(xlUp).Row

Range("C1:C" & LastRow).RemoveDuplicates Columns:=1

Range("A1").Select

End Sub

Answer 4

you're able to initiate off manually yet what you will be able to desire to do, assuming you % to delete row one million, then 3, then 5 etc. is to initiate recording a macro, delete row one million, by precise clicking on row tackle all the way down to delete then clicking on row 3 repeat the technique then give up the macro recording. Then basically run the macro till all your rows have disappeared. then back, its no complication to do it manually till its an absolutly sizeable spreadsheet, click on first row tackle, carry administration key down and click on another one and press delete, or possibly extremely than delete, basically conceal the alternative ones.

Answer 5

Which version of Excel?