When I trying to sort my data in excel there is an error appearing like "the
operation requires the merged cells to be identically sized" and in detailed
it is showing that "This error only appears if you attempted to sort a range
of previously merged cells, but not all cells in ...

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