I'm not sure how to explain this!
I need a total of the number of times that "G" (no quotes)
appears in the range S4:S1516, based on "Ou" (no quotes)
appearing in the same row, in the range J4:J1516.

I have 2 cells that are in the format line of
A1: 27/06/2006  9:42:00 pm
B1:   7/06/2006  9:52:05 pm
Want third column C1: 00:10

How i can open Excel file 2007 in Excel mobile

Greetings.  I have Excel 2007 and Windows XP. I am using a worksheet in Excel
as a hyperlink storage bin (containing links to external files).  I realize
there are many other programs that might be more suitable for this purpose,
but I'd rather keep all these file links in Excel ...

I'm averaging 52 rows which are week totals. I have a result column for the
average. Problem: If I have only say 30 of the 52 weeks currently to
average, the formula that does my week totals has a zero in the week rows
that haven't happened yet, so my running average is way too ...

I would like to be able to make manual line breaks within a cell like you can
in Word.  For instance, I am making a spreadsheet of conferences people in my
office need to go to.  Within a single cell I would like to be able to make
four lines: Confernece name, Dates, Place, and ...

while addressing cells in a spredsheet from PivotTable Excel 2007 always
puts GetPivotData functionautomatically instead, like old versions, simply
addressing cells (like =B3 or simillar). It makes my formulas very long and
not possible to understand. I wonder if I can switch off ...

We have workbooks with several worksheets, up to 50, and all
worksheets are formatted the same.  Is there a way that we can set
page breaks on all these worksheets at one time?  It is not possible
to change the page breaks on multiple worksheets at once in "Page

I know that I should use microsoft.public.excel.mac but looking at their
recent postings and replies, I would find more activity at the local grave
yard.
There is an urgent issue and I hope that there is a quick answer to this.

I have four columns the first with customer, the next with state, the
next with salesman and the next with sales amount.  The customer,
state and saleman will often repeat but not necessarily consecutively
(they are not sorted or grouped in any particular way).

I have a employee job scheduling table that I would like to populate
based on criteria from 2 other tables.
The scheduling table has the employee names listed in each row and
across the top is the period of the day broken into 4 time periods.

Is there any way to rank the cells in a pivot table and have the cells
that rank 1,2, 3 highlight.
example:
if cell ranks, 1 = red, 2 = blue, 3 = yellow

This is similar to another post -- any help would be appreciated
I have a table (Table A) containing rows containing names, time reporting
period, and hours worked
Joe Smith, 12/31/06, 32 hours

I have exported values from a defect tracking system into excel
Each defect is categorized in one of a couple of hundred different
categories.
I want to somehow display the count of the unique categories (and not the

I need a macro or procedure of a sort to print envelopes for family news-letter