View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Clean matrix from 0

Hi! I have a large matrix. Some of the cells contain the value 0. I want to
get a new clean matrix where all 0 cells are removed. I then want to change
the matrix into a long column. The cells that contain 0 shall be removed and
not just replaced with another value. Is that possible? if so how? any help
appreciated!