Formula to eliminate zeros

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: RodG (RodG.17a284_at_excelforum-nospam.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 08:51:42 -0500

I have a column of values that is 200 rows tall. The values are either
a five digit option number or a zero. (I can change the formula that
generates this column to put anything in place of the zeros of that
helps) I need to transfer those option numbers to Work Order in a
concise list without 175 to 200 zeros. I need to do this automatically
with a formula when the data is imported so my purchasing dept. does
not have to filter the numerous lists with each job with a drop down
menu. I could have all of the zeros on the bottom if I can get all of
the five digit option numbers to appear at the top of the list. I keep
getting NUM errors when I use an =LARGE(range,ROW()) formula. My list
looks like the following example:
0
0
45214
0
0
0
12685
0
0
22355
22356
0
0
etc.

I am very greatfull for any help.

Rod 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Formula to eliminate zeros
    ... list descending. ... >a five digit option number or a zero. ... >not have to filter the numerous lists with each job with ... I could have all of the zeros on the bottom if I ...
    (microsoft.public.excel.misc)
  • Formula to eliminate zeros
    ... continuous (no intervening blank rows) ... >>a five digit option number or a zero. ... >>not have to filter the numerous lists with each job with ... I could have all of the zeros on the bottom if I ...
    (microsoft.public.excel.misc)
  • Re: infinity
    ... from that two different infinite expansions in the same base can ... infinite lists are easily constructible in design ... only one sequence with all zeros, and only one sequence with all ones. ... For having one or more zeros with one or more ones there are infinitely ...
    (sci.math)
  • Macro to sort values in list without 0s (zeros)
    ... I have a some lists where I have made a macro so the user can choose to ... the bottom of the list. ... So my list has zeros in it, and I want it sorted A-Z, if i do this is ...
    (microsoft.public.excel.programming)
  • finding a list of numbers in a vector
    ... I have a 16-element long vector of ones and zeros. ... consists of two lists of 6 ones, one touching the start and one ... If 12 boys make a chain within that circle of 16 people, ...
    (comp.soft-sys.matlab)