trying to store non-zero numbers from a list into sequential cells

[Guest]

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

 

[Joseph Meehan]

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

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.