XL2003. I use often use Advanced Filter, but I have one file from a user that
will not play. When I put an advanced filter on it, it returns the entire
table, not just the filtered bits. There are no blank cells in the table, I
have copied it and pasted just the values, I've ...

All of our company's mail needs to be monitored to ensure a prompt response
so I'm trying to create a mail monitoring spreadsheet. Column B is the date
received and Column J is the target date (five working days from date
received)

I have a column of reference numbers, there should be 6 numbers in
each reference, sometimes the leading number is a zero. I am using
=TEXT(B2,"000000") to show all of the digits.
Sometimes the reference column is blank and if that is the case then i

I have a list of 6000 products in column A of sheet 1of a workbook.  In the
next sheet I have a column of those 50 products company X uses, 130 products
that company Y uses, etc.
If I add the column headings for each company to sheet 1, how can I bring to

I was hoping that this formula is plausible.  In A1 there is a date
14/04/2010, what I am looking for in B1 is a forumla that will tell how many
months are remining from today's date.
A1                       B1

Excel 2007.
Big spreadsheet.  15000 rows.  
One column has for some reason randomly added a question mark at the end of
a bunch one word text in this column (they're brand names).  I want to

I'd like to paste a formula in one column every 5th row referencing cells in
another column in which the rows are spaced together.  In other words, I'd
like to paste in cell A1 the formula =B1*3, and in A6 =B2*3, and so on.  Is
there a way to do this without entering a separate ...

Is it possible to unlock a cell dependent on a specific value being entered
in anther cell in the same row?

I have many heritage Lotus 1-2-3 files which I have been able to open before,
but when I tried to open one of them today, I receive the following:
    "You are attempting to open a file type that is blocked by your
registry policy setting."

Every time i try to utilize the add in button, i get the error message that
Excel must close.  what's the story here?  I've previously used add ins with
no problem,
thanks for any help

Anyone know how to do the Sl.No. in excel?
The condition is if you filter any row, the Sl.No should be changed
automatically.
With Regards,

I'm working with a calculated field in a PivotTable.  The formula I am using
in the calculated field is below.  The value in one row for UL is 0.2471 and
the value for LL is 0.  I am getting #VALUE! for the result in the
PivotTable.  I am actually getting the Reject value if I ...

I'm sure there's a way to do it, but I'm just starting to play with VB and I
don't know too much yet about it (this discussion group being filled with
kind people who seem to enjoy puzzles, I take a chance :-)
If I select a cell or range within column D, for every EMPTY cell of ...

I use Networkdays formula to calculate difference bwtween 2 dates,if the end
date is beyond 12 hours the formula returns 1, so my calculation of SLA is
going vague.
Is there any formula that we can use which will exclude weekdays and will

I have a table with headers in the first two rows.  How can I scroll through
my table and "lock" the first two rows remain on top?
Thanks,
Ellen