Thread: Excell function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daly Daly is offline
external usenet poster
 
Posts: 4
Default Excell function

I have two columns :
size quantity
0 0
120 2
0 0
140 1
220 2

how can i convert these 2 columns in only one without 0 value and display
the value as shown below :
120
120
140
220
220




--
thank you & best regards