What formula can i use that can count the number of rows that have
specified text?
for example:
A                 B              C

I have a Daily Report that my guys have to fill out when on the job.  The
worksheets for their first three days are already set up and I have a blank
worksheet for them to copy and use for additional days.  We have to keep
track of daily total hours and project total hours, so ...

So I'm trying to randomly select a cell from a colum of cards.  I used the
function ADDRESS and RANDBETWEEN to get a random cell number
=ADDRESS((RANDBETWEEN(2,53)),1,4) to get a random cell from a list in colum
A.  Now, I can't use that result (random cell number) for anything.  ...

What I am looking for is a way to locate supplies.  I have been told that a
VLOOKUP would work but I cannot seem to come up with the proper syntax.  What
I am looking for is to have a dialog box that I would enter the STORE DESC
and have it list all of the items that come under ...

I have multple sheets.  
Sheet A with
Name, Dept#,Phone,Manager
John Doe, 1105, 123-123-1234, blank

I'm trying to create an order form and want to use a validation list in A1
with ACCESSORY selections PROP, INSTRUMENT, HARNESS etc and based upon that
selection, I want another list in B1 which gives options available for PROP,
i.e.

i've fitered to unique records only - how do I paste visable cells only?

I am trying to match data in a formula and the cell contains an alph
numeric value....with spaces...ughhhh
e.g. VK 1234 RAM which is in A2
What I need to retrieve is lookup the value in A2:A6, find exact matc

When I enter a sum value for more than 30 cells in a column the formula
appears in the cell that I want the total to appear. Help me please

My Conditional Formatting option under Format on the Menu bar is disabled.  
Why would that be?  It used to be enabled.
Thank you,
Steven

I am creating a large matrix analysis of for my company. I need  the
value of each cell (0 to 1.0) in my matrix to be displayed in different
colors depending on what value band it falls within. I need at least 6
color bands (e.g values less than 0.1 to be blue, values between 0.1

Would also be helpful if there were similar formulae that would provide the
ability to either add 1 day or add 1 year to the current date......Of course
it needs to take into account leap years and other problems.....can anyone
help

I have a dynamic list entered in columns.  I am trying to take one of those
columns and concatenate it into a single cell to be copied directly to a
separate form in the format required.  My problem is that the list is dynamic
in both the number of records and the data.  It is ...

I have a column of data that is formatted with general text in yymmdd format,
and for the purposes of a formula, I need it to represent in date format of
mm/dd/yy.  I have tried formatting the column, using datevalue, edate,
selecting the column and converting the text to column, ...

Im trying to create a formula to average some figures that are not next
to each other. I also do not want to include the zero amounts. The
formula in the help section of excel for Calculating the average of
numbers, ignoring zero (0) values is (=AVERAGE(IF(A2:A7<>0, A2:A7,"")))