Eliminating zeros, null values and negatives in a column

		Microsoft Office Forums > Microsoft Excel > Excel
Eliminating zeros, null values and negatives in a column

06-22-2011, 07:03 PM

Catalin.B

Windows Vista Eliminating zeros, null values and negatives in a column

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

You just have to use a filter: go to Data-Filter-Number filter-Greater than...and enter value 0, to sort only values greater than 0..
Good Luck!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM
Zeros or "O" as text	bobsalas	Word	1	01-29-2011 02:39 AM
Using Conditions to Add Values	EclipticalD	Excel	1	07-08-2010 09:50 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
How Do I Replace Nulls With Zeros?	deekadelic	Excel	1	08-11-2006 09:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:51 PM.