Re: formatting columns

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ragdyer (RagDyer_at_cutoutmsn.com)
Date: 05/09/04 

Date: Sun, 9 May 2004 14:48:27 -0700

It would be better for you Sue, and the rest of the folks who are willing to
assist you if you would stay with your original post.
In that way, all would know what was already suggested, and what perhaps
didn't work for you, so that they wouldn't duplicate suggestions that you
might have already rejected for one reason or another.

Could you tell me what didn't work for you when you tried the Choose formula
that I had suggested three days ago?
Even though the formula I posted only showed four choices, I did mention
that there was the ability to utilize the function to return 29 choices. 

-- 
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"sue" <anonymous@discussions.microsoft.com> wrote in message
news:a6a901c435cc$e77e9690$a601280a@phx.gbl...
> Thanks everyone, but let me explain my situation.
> I am preparing to set up a database in Access2002.  My old
> database is Clarion.  It was already antiquated when the
> department had ITS set it up 7 years ago, and I have to
> export to Excel any time I need to pull reports or due
> mailmerge with Word docs. That's why I'm setting up the
> Access database.  However I'm having a hard time
> convincing my not so computer savvy boss to let me use
> Access.  He knows how to use Excel on a limited basis...a
> very limited basis. It will be a few months before I will
> have the time to set up the Access database so I must do
> my data entry into Excel.
>
> There are already 8800 entries.  Therefore I need the
> entire column formatted for the one formula.  AutoFill
> takes care of most of the other 36 columns of
> information.  I'm just trying to get the two columns to
> work together, as well has having 4 other columns
> automatically have something in them, that I can overwrite
> if needed. This last part I know how to do... I think.
>
> So... If I type a 1 in Column A, dogs should appear when I
> tab to B.  If I type a 2 in the next row, cats should
> appear when I tab to B.  But... I need this for all 16000
> plus rows in the work***! Is there no way to highlight
> the entire column when I put the formula in... in other
> words, is there a formula that would automatically include
> every cell in the column, instead of my typing the formula
> in the first cell, and then having to drap it down the
> whole column.
>
> Also, if creating the spread*** ahead of time, and then
> protecting the one column...can I copy the current
> spread***, with all the info in it from the Clarion
> database?  Basically what I need is a formula that will
> work for the whole column, for 8 different choices.
>
> I've tried the =IF(A1:A16000,"dogs", .... that didn't work.
>
>
Quantcast