software

I have a pivot table that has columns quot;lt;5quot;, quot;5-7quot;, quot;7-10quot;, quot;10-12quot;
and quot;gt;12quot;. However, when the pivot table comes up, they are out of

I want to create a column chart that has one data series on the left axis,
and the other series on the right axis. Pretty easy if you want the 2nd axis

When I use the IF function in most cases, I want it to either show some text
or nothing at all. I have always performed this function as in the following

i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value

If I wanted my answer in degrees for the following: opp side 8.3ft divided
by adjacent side 5.8ft should give me 55.05 degrees. I have no problem with

got it! At one point I had highlited all of the sheets in my workbook. Some
how excel grouped them together and wouldn't let me do certain functions.

i have 3 dates referring to a period and where i want under the formula cells
to have the following

I have created a monthly Canadian ammortization excel spreadsheet, but I

I have tried insert code into a macro that will not allow users to use the
cut/copy and past mode. It didn't work. I was told to make it an auto run

I have Data Validation set up and it is NOT preventing entries that are not
in my data list. I have one sheet with the data list (A1:A15) and the range

I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The

Hi,

My guess is that the problem is becuase the EOMONTH formula is part of the
analysis tool pack.

Hi Guys,

I'm trying to write a custom function in VBE to determine if my data falls
into one of three categories, active, inactive, or future, for functions that

I just created a simple worksheet to total volunteer hours that help with
band boosters. It then occurred to me that I could build a workbook that

I am experiencing a very frustrating problem. I have a number of

Excel automatically places a space after a full stop/decimal point. this
results in it not recognising numbers as numbers... any help gratefully

I've been trying to put 2 pies of comparable data (1 for men and 1 for women)
on a single chart but despite trying to use the secondary access, I can't

i have some data that is organized terribly, and it's HUGE.