Remove undesired values in a column

**S K ROY** · 11-09-2011, 04:14 PM

Hello!
I am dealing with a large set of numbers (>32000). First I have to remove all negative numbers in the column. Is there any quicker way so that instead of searching and removing one by one?

I have to restrict the numbers to 32000. So I want to remove very close values from the list so that total numbers remains within the limit of 32k. Is there a way out?

Thanks in advance.

**ChemistB** · 11-09-2011, 04:18 PM

Depends on what you are allowed to do. You can sort by that column and then delete rows 2 through whatever which are negative. Or you can filter using a "number filter" and "Less than" 0. then delete those rows.

I am not sure what you mean by your second statement in your post.

**S K ROY** · 11-09-2011, 04:30 PM

Thanks ChemistB. For the first problem do I have to remove the numbers one by one or it will sort and remove those rows automatically?
In second query I want to remove number value which is very close to next or previous number value in the column. I need to do this to restrict the total rows to 32k. Could I make it clear? Thanks again.

**ChemistB** · 11-09-2011, 04:40 PM

Once you filter, you can select all the rows still showing, right click and "Delete Row" then Clear the filter.

For the second part, in a column next to the column of numbers (assuming numbers are accending) enter an equation like so

=AND(A3-A2<0.1, B1=FALSE) (replacing 0.1 with whatever you deem to be close enough together to want to delete.