If I put = Row() in a column of cells I get the row number.
Now, suppose I filter the data.  I want to show the sequence row number
of the filtered data so that it shows 1,2,3,4,5 etc regardless of the
actual row number.

I have some data for a pivot table that looks like this
Year     ; Messages ; Replies   ; Amount
2005    ; 1064         ; 42         ; 100
2006    ; 1064         ;   3         ; 100

I have this user that says when she opens Excel the only options she
has is to go into File or View.  She has no Tools, Help, etc.  She has
reinstalled Excel to no avail.  Has anyone ever seen or heard of this??
Thanks

i transfer bank statements to excel for later reference, and in one of
them i would like to conditionally format the whole row to be red (or
if this is not possible then the relevant cell) if the payment box
contains a minus sign.

I have a long list of data.
Every fourth row contains the sort of data (ID, name, points...)
Unfortunately the data is all in one long column.
Can someone tell me how to select out every fourth row?

I am looking for an easier way to refresh a pivot table (to avoid any
complications with the PivotTable toolbar and to avoid the select/right
click/refresh thing.
Ideally I would be able to add the ! Refresh button directly into the

Has anyone organized sales and production of fine art photographic prints.
I need to keep listing of subjects name and address, mnodel release or not,
and other information that comes up related to records I may need in the
future.

I am trying to create a function which will let me know when a particular
date has passed or expired.  For example, a person has insurance which
expires on 4/30/06 - I want something that will let me know on 4/31/06 that
that person's insurance is expired.  Maybe also create a ...

I have spent HOURS on this...
Very simple, all I need to do is convert a column of about 1600 items
to an array 12 items wide.
Help???

is it possible to draw floor plans using office

Is Excel 2007 released ? If not when is microsoft planning to release Excel
2007 ?

Can't figure this one out.  Every once in a while when I left click my mouse
to highlight cells the highlighting action won't stop.  It doesn't appear to
be a failure of the gidepoint mouse on the notebook, because the problem
won't manifest itself on other spreadsheets or other ...

have cell A1 formatted as a number with 12.34 in it. Want to have cell B1
reference A1, but be formatted as text so it can be used for other purposes.
How can this be done?

I have a worksheet that uses data validation with a Sumif()
restriction.  I want to add another Sumif() restriction on the same
range of cells.  Is this possible?  
Thanks in advance-

I am having some trouble opening XML in Excel.  I have a web program that
will perform a query and export the results in XML format.  I have some users
on Office 2003 PRO and SBE, whenever a user opens the file in PRO, they get a
dialog box that prompts them with three options, ...