My worksheet looks likes this:
   A           B
1 Name    Fruit
2 Sam    Apple

Does anyone know the formula for random name selection using one
column?
thanks,

I need help in giving color to Column A cells based on the values in Column B
cells. For example:
  A          B
1 car       y5

I can make a drop down list, however I need to be able to select more than
one option. Nay help would be great

I am using a spreadsheet now that does this, but I would like to know how it
was done?  It saves time when you don't have to put in the "=" sign before
using any functions....
Thank you,

I was given a report that includes a total list of names of people, and you
are able to open it to one paticular person to review their information etc.
There is a comments part that is suppose to print the comments at the end.
When I bring up one person to print only their ...

The cell's text is:
Reclassed to 101-001-4455-003.
I want to find the position of the first number, which in this case would be
the number "1" and it would be in the 14th place (if I counted right!). The

I have a spread sheet that lists my reports by "customer name" in column "A"
and the "date the report was completed" in column "B".  The date is formatted
mm/dd/yy (08/16/06).
I need a formula that gives me the number of reports that were completed in

I'm running a spreadsheet to show recruitment campaigns at stores. I have
'start date' in one colum, 'end date' in next column. I have dates of month
in following columns. I've tried a formula in conditional formatting to turn
the relevant dates in a campaign 'shaded', if they ...

I have a column where all formulas are the same except row number.  Some of
the formulas are returning '#N/A' when I open the file.  The formulas link to
another file.  When I open the other file, the values update correctly.  Only
about a dozen blocks are doing this.  All other ...

Is there a way to quickly find just posts by a single user and the
subsequent threads?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I am attempting to update an email list.  I have exported from Outlook all of
the emails that were returned to me because of a bad email address.  Some of
the address' are in a column along with a bunch of other words.  My goal is
to "pull" only the email address' out of that ...

I have searched around for an answer but have not found something that
specifially deals with my issue, so I apologize in advance if this was
already answered.
      a           b              c            d            e    

Hi.  I need to use something like a switch function.
I thought it was just "Switch" as it says here (and a couple of other
websites):
http://www.techonthenet.com/excel/formulas/switch.php

I have a sheet with about 3000 rows for claim data. Column B shows Date,
Column C shows amount. The date range spans many years. I want to sub-total
amount per callendar year. I tried SUMIF but could not make it work. Any
ideas?