software

I use the subtotal(9,..) function quite a lot and want to add a toolbar
button to make it easier to use. I've tried various macros etc to do this

What would the function (if any) be to calculate the number of weeks between
two dates.

Hello,
I have been trying to figure out how to use the Static Data Consolidation

Hi,
in my book i have a cell with data validation set up to collect data from a

we need that users will enter same exact values in 2 different colums. the
reson being is that the spreadsheet data is uploaded to DB. later on a

I have about 200 files that have a spreadsheet of active jobs (each job

I have a model that takes a whole range of inputs to give you a final
amount you can borrow. I would like to use something like the

OK, I know the limit of 7 nested ifs, and the vlookup function. But what I
am try to do is the following:

Hi, everyone. I have a simple question about the excell setting.

I have several tables in the same tab. I would like to be able to apply
independent autofilters to each table and display filtered results for

I already have an Excel table which calculates projected milestone dates from
given start and finish dates, and then compares those dates with the actual

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing

I am trying to set something up so I can keep track of some of my customers
that are on a payment plan but I can't figure out how to set it up and have

I received a Word Doc with names and address of clients. I have to export
them into Excel but they are showing into rows and I would like them to

How can I copy a formula that references another sheet to a new filequot;

I have two questions. I have three columns that will have a calendar date in
them. On the fourth column, I need to put in a formula that will count the

I need to conditional format a cell based on the condition of a

I have a data table containing 52 weeks data on 20 people e.g. number of
holidays taken in a particular week, Income in a particular week.

Hi all,

Is there any way of being able to enter a number into a cell and that number
will represent the width of the column? For example, if I wanted the cell to