![]() |
#1
|
|||
|
|||
![]()
I have columns of number volumes for oil, water and gas. Example: column A may have 100 numbers in it. Let's say: 10.00, 30.00 .02, 0,-.05, 1000.00, 2.00, 0, nothing, nothing, 0, 1.00 and so on. It can be any volume. What I want is a formula that removes all the zeros, all the nulls and any negative numbers. And puts the numbers in order eliminating the ones I don't want. Example it would end up like this (using numbers shown earlier). 10.00, 30,00, .02, 1000.00, 2.00, 1.00. Does anyone have any ideas on how to do this?
|
#2
|
|||
|
|||
![]()
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! |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
Zeros or "O" as text | bobsalas | Word | 1 | 01-29-2011 02:39 AM |
![]() |
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
![]() |
deekadelic | Excel | 1 | 08-11-2006 09:52 PM |