Does anyone have a self calculating time sheet that will work in office 2000? Need to use for shifts starting PM ending in AM

I would like to count the cells that have a value in font color red and not count the cells in font color black, how can i achieve this?

I am building a set of spreadsheets to record results and points for a fantasy sport game. I have designed it so that the user inputs all data on one sheet....

I have a spreadsheet with names in column A & addresses in column B, exported from another application. Unfortunately the addresses have been spread over...

Hi, I have a sheet with 6000 entries and associated risks How do I get a list of the property with the highest risk. eg Site risk 1 8 1 14 1 6 2 5 2 15

Hello I use the random between function to randomly select employees for testing. I've outlined the problem I'm having below. Each employee is required to...

i'm new to excel & what i'm trying to do is; lookup two cells (A2:B2) in sheet1 & find the matching data in sheet2 (A2:B20) and return the data in column...

i have an excel file that is approx 45 columns by 250 rows. I would like to be able to keep my first 4 columns and first 2 rows constantly visible whilst...

I am trying to highlight numbers in Column B (B4 to B5000) based on if Column L contains an X. If column L has an X, I want it to highlight the value in...

I have experienced nothing but frustration with this excel in office 2007. I am supposed to be using it for my statistics class but it has been veritabley...

Excel 2003 I need to reference the value of a cell in a different worksheet and I want the name of the referenced worksheet to be determined by the text...

Dear All I have a worksheet where all the values produced by list and all the cells have either yes or no. In the columns i have scenario by person, so...

Vlookup using a dropdown list, check different tables based on dropdown list selection. Country Dropdown list, 10 different countries (for starts). Each...

Dear Expert, I have a cell containing text as follows: R:\Team A \Client Vals\Equity Derivatives\Daily\Valuations Temp\Fixings.xls How can I display the...

I am trying to use the Excel Workbook as an exam for my students. I have a column for their answers and then a hidden column with the correct answers. I have...

Hello, I am trying to use Excel data to form a column for a seating chart that I am designing in Adobe Illustrator. I need the data within the cell to list...

-- nothappy

Using office 2007, we receive a large table with the following columns: Date, DayOfWeek, Hour1, Hour2….Hour24: Date HE01 HE02 … ...

I have a table with years across the top and months in the first column. Within the table is data for each month of each year. Is there a way I can point to...

Dear Expert, Want to copy a function from one spreadsheet to another spreadsheet (different file name). I just want to copy a function (as follows) from...