I have a list of pay records in rows, with an employee ID# in column A for each one, which they are sorted by. An employee may have multiple entries each....

Hi, I tried to do a sumifs for my simple spreadsheet but could make it works. I have a table with EmpID column, Plan elem, and the weighted avg %, I want to...

I cant select and unhide rows or columns on a worksheet, I have tried different protection methods... can someone show me how to unhide/unprotect a worksheet...

Hi, Every month we make a list of our employees working hours. ex. monday 10.00 - 16.00 = 6h tuesday 16.00 - 20.00 = 4h total 10h

I cannot open my installed version of Microsoft Small Business Edition 2003, nor Works 8.5 on my XP computer. I get an error message #1305 that says I don't...

I want to assign a numerical value to a cell based on the selection of one of eleven options within a drop-down menu. This numerical value will be used in a...

I want to work out the total percentage of 2 sums, For example Matthew worked 5 hours stacking shelfs, in this time he stacked 40 shelves, his target was to...

I need a macro that will insert a number of blank rows based on the number of months between a start and end date and then copy the information in the...

I just uninstalled and reinstalled Excel 2003. Before, when I had multiple Excel files open, I could move between them swiftly within Excel using Alt-F6. But...

I am trying to randomly select a percentage from a list of 891 for assessment interviews. Do I use Rand ()*.1 for 10 percent of the selection?

I have a large data sheet of order pending list in which I look for a text in $B$2175 and determine the area of target cells. In this sheet they can be...

I often need to calculate student age as of a specific date. For example: A1: DOB A2: age as of Sept 30, 2010 I need a formula that will also work if I need...

When I write SUM(Sheet1:Sheet4!B4:B6), that works. But if I change the function name to SUMPRODUCT, I get a #REF error. Copied from the Formula...

Hello, I would like to ask for help with a formula. I report onto a second sheet the referenced cell unless it meets one of the following criteria. For...

I've created a 'fillable form' and somehow (magically) when the tab key is pressed in certain cells, the cursor jumps to the next appropriate cell to be...

I have an Excel 07 table. It has a vertical column of names and then horizontal headings of organization, software, version, if it's licensed, and a few...

Does anyone have any suggestions on how to clear Excel's clipboard memory? If I exit excel, will all clipboard memory be automatically deleted? Thanks in...

We are trying to copy a worksheet in Excel and we get the notice that the sheet we are trying to copy contains the name '_Fill' and '_Key1' which already...

I have created an Excel workbook which contains multiple worksheets of financial data. what I need to know is How do I get the financial data totals from...

Col A Col B ColC Col D Col E Col F Col G Col H Row1 . . . x . . ...