Clean matrix from 0

[Guest]

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!

 

[Guest]

To remove the zeros:

Select the range of cells representing your matrix
Use Find & Replace - finding the zeros, replaicng with nothing, but be sure
TO CLICK ON THE OPTIONS button and check "Match entire cell contents"

 

[Gord Dibben]

Arne

By "remove" I assume you want those cells deleted, not just turned blank.

Which way would you want them shifted.....up or left?

Then in which orientation would you want the remaining data placed into the one
column?


Gord Dibben MS Excel MVP