General

Equations in fil not being read correctly
Ok, so below is the equation I have with my cells I am having trouble with: =INDEX('Front End-MSP'!A1:A22,RANDBETWEEN(1,COUNTA('Front End-MSP'!A1:A22)),RANDBETWEEN(1,1)) I have excel 2007 at home on my PC, at my office we only have 2003 version. The equation above work perfectly at home, but when I attempt to... 9 Jul 2008 01:25

Direct path to Worksheet
Hello, I was trying to figure out a way to write a direct path to a worksheet in a workbook, is there a way? i.e. c:\My Documents\Excel Files\Sales.xls [Jun '08] Where "Jun '08" is the name of the worksheet in the Sales.xls file. And maybe if possible even add the name of a graph in that worksheet to the path ... 8 Jul 2008 22:21

help with vbscript to average a report of dates
I am working on trying to average data on an employee report(175 employees and 18 courses). The report list the employee name and if they took the computer course it populates a cell with the date completed. If the course was not taken it leaves the field blank. I need to know the % of courses completed for each em... 8 Jul 2008 21:20

How to Find Incompatible Cell Formatting XL 2003 / 2007 ??
(This is a cross-post) Hello; I'm trying to see how easy or difficult the task is of converting from XL 2003 to XL 2007. I selected a relatively simple 2003 file, and been able to sort out the macro security, macros codes, events, vba references & libraries, etc. So far so good! One remaining difficulty... 9 Jul 2008 14:44

Have cursor go to specific place when worksheet opens?
Is there any way to make the cursor go to a specific cell every time the user accesses that worksheet from a sheet tab? ... 8 Jul 2008 23:23

Repeat same data entry to multiple worksheets without Group Functi
Can anyone help How can I add data to one column of a worksheet and have the data automatically add to the same column of several other worksheets without having to group all the worksheets each time I enter data. Thanks ... 9 Jul 2008 15:47

CAGR for short sales using XIRR
I am trying to calculate the annual growth rate for a short sale. I've entered the first amount as a positive number (because it was cash coming in) and the second amount as a negative number (because it was cash going out). When I use XIRR I get a negative percentage as the annualized return. As a simple ex... 9 Jul 2008 10:37

How can I randomly sort a column of data using Excel?
A bowling league consisting of an equal number of men and women would like to do a blind draw of two person teams (one male & one female) randomly each night of play so that the teams members will be different each week and randomly selected. ... 8 Jul 2008 20:18

shading
If I click and hold the mouse, then drag it over numerous cells, they are highlited with color. The contrast between this color and the white background is too light (not enough contrast). Can this type of highlite color be changed? ... 8 Jul 2008 20:18

Running total within IF
Hi, I'm looking for a formula which will add together all of the values from a range if they are negative... (only if they are negative) So far, I've used the countif function to count how many positive and negative results are recorded. - okay for the project at the moment, as values 1 or -1 or 0 will be entere... 8 Jul 2008 20:18