Is there a way to count a cell based on it's color?  I have a series
of scores that I track for the month and I want to count any cells
that are gray.  I can't figure out a formula that will do this for
me.  Does anyone have any ideas?  Feel free to email me at

After filtering a list, how do I save only the filtered result "as it is" on
the same sheet and discard the rest?  Please help...thanks.

Hello all...
I have data from 6 separate events.... event A was finished at 9:05
74.05% of the time... each event is listed that way...So my data looks
like this...

Apologies if this is not the correct forum for this problem.  While no
a new Excel user, I am new to OF.
Recently I downloaded an Excel file with a list of DTV converters. Thi
file opened up with a band on the left side (left of the row numbers

I have a range, A2:A11. In cell  I have this Datavalidation rule that
ensures, that the only tinh you can type is 1. (The figure 1). I A13 I have
SUM(A2:A11), and in A14 I have maybe 6. The value in A14 is the max value
that A13 must reach. My problem now is,  how do I make a ...

I have a form where you enter minutes but the calculation needs to give the
result in Hr:min. I've tried
A2=180 A3=20=SUM(A2,A3)/60
The result being 3.3 but I need it to show 3hrs 20 min

I have two excel files.  
One file has vendor number and vendor name.
The second file has vendor number and payment information based on vendor
number.

Hey guys
I have bunch of numbers in different decimals in column B and C
I try to compare whether value in cells next to each other are same or
not.

This is the problem I have with few excel sheets but not with all. When I
select a range of cells including the Column headers and go for Data - >
Pivot table and Pivot Chart report ... and click on Next , I can see
"Database" in the Range field rather than the range (example : ...

I am trying to enter a 18 digit number in one cell. Surprisingly, the
lasst two digits are automatically being changed to 00.
The number i tried to enter is - 857013340418093014. The last two
digits i.e. 14 is automatically changed to 00!

How can I change the Look in default from My Document to another drive?
Thanks.
Menk

I have a spreadsheet with a list of hyperlinks to other documents. Is
it possible to disable these temporarily? I have am trying to copy the
hyperlinks to a table but I keep accidentally triggering them. Ideally
I would like to temporarily disable the hyperlinks until I have

The 2 data sets are assumed running in A3 and in B3 down, viz.:
In A3 down is: A, B, C, D and E
In B3 down is: 35, 45, 13, 8 and 3.
The result which I want is to list the data E, D, C, A and B from the cell C3

Anyone know how to set an input mask for cells in excel.  I would like
to have the date displayed when I type without having to type the / or
-.  
TIA

I'm new to use of Win Mobile 6.  When I paste in a .xlsx file from Excel 2007
in my PC, using Windows Mobile Device Center on the PC, the file transfers
into a directory on the PDA, but it isn't accessed by Excel Mobile 6.  
If I first convert the file to an Excel 97-2003 format, ...