I am accessing a website that generates csv reports for many different
facilities I service. The csv files all have the same name and, subsequently,
the same URL. There is some kind of backend script that generates these files
and opens them in Excel for me automatically when I ...

When solving for NPER, I've had a couple of occasions where  Excel
returns #NUM!
But if I changed the PMT amount (not changing the +/- sign, just the
amount), I found that the error only occurred at a certain value and

I have a workbook with 35 tabs. I am looking for a formula that if the value
on worksheet 38,cell  g57 is > then 7, print, worksheet name 35,cell range
a10:f30.
Is there such a formula?

I use a spreadsheet that I created myself as a template, and we use zeros and
ones to 'add up' scores.  To keep track of the zeros we use superscript.  For
one, two or three zeros we use a symbol so that it can be copied and pasted
to another cell.  I am now using a formula that ...

Why is it every other cell will show the number value, but one cell will only
show ###### in the cell? How do I correct this? Thanks.

My first sheet is an overview sheet for a budget.  I have the names of all
the other sheets in the first column and some code to pull each worksheet
name and put in in that column on opening.  In the second column I want to
pull the name of the worksheet from the first column and ...

I probably ought to know this, but:
How can I copy a formula that will increment as necessary (A2, A3, A4 etc)
down a whole column.  Currently I am dragging the corner down so far and
then having to remember how far I've gone. How should I really be doing it

i have a budget with a bunch of sheets.  The first sheet (sheet1) is to be a
summary sheet.
In the summary sheet I'd like to be able to make a cell name dependent on
the tab name of other sheets.  That way I only have to change the name in one

How can I repeat range of cells in footer as like "repeat rows on
top".?
Pls help me.
Thks

i wantb to creat oncall schedule for doctors in a hospital. each 2 doctors
would be on call for 12 hours a day. it can look like calendar and it should
calculae how many days each one was oncall up to date.

I need to get up to speed very quickly on Excel modelling, especially
financial modelling. Would someone pls recommend some good free online
resource to learn up on excel functions that are useful for financial
modelling.

I want to protect a workbook so that the formulas and objects are not moved,
but when I looked at the options it seemed like my only options are for
opening the file and not modifying any of it. Is this correct?

I have a list of names in column A, e.g. A1 contains Mr. & Mrs. Homer
Simpson, A2 Mr. F. Smith, etc.
I want to extract the last name so the B1 contains Simpson, B2 Smith, etc.
I'm sure it can't be that difficult but after two hours of trying...

This is the first time I have ever posted a question on the internet,
so bear with me, I will do my best to be clear and concise for anyone
who may be interested in helping me look good to my boss! :))
Seems the easiest way to do this is tell you what I need the formula to

I have been using the advancedfilter and the vbe for filter specificed
data. Though I have marked unique=true,same data of different invoices
still appear. I  even tried by delete the invoice number column but it
did not help