A
Ausseshooter
I am a complete novice with Excell, I am using Excell 2002. I have list of
numbers, some zero some none zero, I am trying to extract the non-zero
numbers and store them in sequential cells (i.e. if a1>0 then store it in x1,
if a2>0 then store it in x2, etc) but can't figure out how to get the cell to
iterate. There doesn't appear to be a "For" function ("for x=1 to 10, ...,
next") and you can only "nest" 7 "if" functions (which seems a terribly
cumbersome way of doing it anyhow). Any suggestions (please keep them simple
- I ain't all that bright) - thanks
numbers, some zero some none zero, I am trying to extract the non-zero
numbers and store them in sequential cells (i.e. if a1>0 then store it in x1,
if a2>0 then store it in x2, etc) but can't figure out how to get the cell to
iterate. There doesn't appear to be a "For" function ("for x=1 to 10, ...,
next") and you can only "nest" 7 "if" functions (which seems a terribly
cumbersome way of doing it anyhow). Any suggestions (please keep them simple
- I ain't all that bright) - thanks