Formula to eliminate zeros

[RodG]

I have a column of values that is 200 rows tall. The values are eithe
a five digit option number or a zero. (I can change the formula tha
generates this column to put anything in place of the zeros of tha
helps) I need to transfer those option numbers to Work Order in
concise list without 175 to 200 zeros. I need to do this automaticall
with a formula when the data is imported so my purchasing dept. doe
not have to filter the numerous lists with each job with a drop dow
menu. I could have all of the zeros on the bottom if I can get all o
the five digit option numbers to appear at the top of the list. I kee
getting NUM errors when I use an =LARGE(range,ROW()) formula. My lis
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.

Ro

 

[hcj]

If the list is a constant length from run to run (always
200 rows), you could add a macro button that sorts the
list descending.
Just a thought.

 

[hcj]

Actually, the list doesn't have to be a constant length as
long as it always starts in the same cell and is
continuous (no intervening blank rows)