How can I shade multiple rows at the same time, for example all odd row
numbers in gray, all even numbers in blue? I am sure there is a better way of
doing it than manualy row by row. Thank you for your help.

I have 2 columns of data, several thousand rows and growing.  Column B has
120 unique entries.  Column C has 500 unique entries.  I am using the
following array formula (very successfully thanks to Biff) to pull out the
unique entries from Column C.  

Thanks to Conan for answering my first similar question!
I now have a follow-up question.
Consider this data:
                 Col A          Col B         Col C           Col D  

I am trying to determine whether or not a sales amount is "In-State" or "Out
of State" for sales tax purposes.  Spreadsheet example is below.  
The formula I wrote for Column E is: =IF(a1=IL,d1,0)  
The formula for Column F is: =IF(a1=IL,0,d1).  

I have been using the LOOKUP function for a long time.  It worked with very
little problems in Excel 2003.  I am having a problem in Excel 2007.  For
some reason it will not give me an exact match.  It will only return a value
that is approximate.  I have tried using VLOOKUP and ...

How do I change the color of a cell to green if the cell contains the phrase
"TBN" anywhere within the text

I have a monthly calendar with the 'Month' in cell A2, the day (ddd) of
month in cell A3:A30, then the day (dd) of the month in B3:B30. Then I have
employee names in C2:C10. What I am trying to come up with, is a table that
shows what day of the week the employee has off, like ...

In a woorkbook I have two sheets
In one sheet I got a tabel With exchange rates one coulom per month and one
row per currency
                             January February

Good day!
I was hoping someone could help me with what is probably a very simple
formula.  I have a sheet that holds customer data with different products and
prices.  On a separate sheet with past customer purchases, I would like to

Formula to determine age based on date of birth (08/13/48)?

I want column a to take column b and come up with the date that would be 7
days after the date in col b.  Is there any way to do that?  Thanks for any
help you can give me.

I accidentally hit disable on my workbook then closed. Now when I try to open
my workbook (that now has a xlms extention) I get This file is not a
recognizable format, how do I get my work back to where it was?

In my data table I used Alt-Enter to include multiple lines of info for each
vendor.  I used the VLOOKUP function but the results are returned with a box
separating each line of info rather than returning the info in the same
format.  Is there a way to get the info returned in ...

I have been raking my head over this simple report since some hours now, but
finally I throw in the towel and hand it over to the experts on this forum to
guide me.
I have a spreadsheet with following columns:

I am trying to count the number of occurrences
a text based instance occurs
within a date range
based upon the text found within the Activity.