If I have a spreadsheet and I make it where there are blank cells between by
data, I then sort and the blank lines are then removed.  How do I easily
insert blank cells throught by spreadsheet without physically inserting the
row on every line.

I'm trying to use the SUMPRODUCT trick to count occurrences of multiple
match criteria.
With simple conditions like checking if a cell in a range is >0, the
trick works fine.

I progmed comment in the macro
when I stand on the coment I see black comment
when I edit the comment I can see the comment
in another computer its work right

I have a workbook with two sheets of about 40,000 rows each, when I try to
use the Multiple Consolidation Ranges option I don't see what is expected in
the field list ie. a list of the column/row names.  Instead I get "row column
value".

I would like to create a macro that when it opened the workbook, it would
remove all pictures (which are tickmarks).  Is there a way to do this or do I
have to do it manually.  Any help will be greatly appreciated.  Thank You.

Appreciate any help please
For example In O10:O1000 I have numbers such as...
56.50
100.00

here is how my function looks like. Also i am using this in formula
like =check("A1")
function check(cell)
{

Hi Groupies
I would like to be able to see which cell the Max function is referring to.
For example: I have a list of values in B1 - B250. The Max function returns
the highest value in that range, but I would also like to find out which cell

We have a file with FAQ's about various job processes....
We want our users to be able to SEARCH the FAQ's without having to use Auto
Filter.  I guess I would say we want the Search ability to be more free form.
Is this possible in Excel?

I was wondering if you could help me?  How would I express this in an Excel
statement?:
Rates are as follows:
Up to 55,000 x .5% of total property value

I've been working on this formula for hours and I'm not coming up with
anything that works!
I need a formula that will calculate the following:
If x is less than .95 OR greater than 1.05, cell will read MISS

I have a two columns containing items with differents costs and I have two
cells with a Qty of $100 ea., My question! Is there a way to calculate the
maximum number of items I can get with the first $100 and then the next $100,
without repeating an item and then listing which ...

I am attempting to do a COUNTIF on a long series of values. I need to count
among the first 100 values for all of the 1, 2, 3, 4. Then count among the
next 100 (101-200) for 1,2,3,4. (repeat 25 times) I am having to go into each
formula and type in the range of cells. Is there a ...

I am working with a tracking form for hours worked.
E12=11:00 AM
E13=11:30 AM  etc
F12=12:00 PM

I need to keep track of compensatory time earned and accumulated.  
Compensatory time is paid out at time and one-half.  When calculating 7.75
hours worked at time and one-half, you get 11.625 hours.  I need to round
this up to 11.75 hours.  Can anyone help?