I am creating a table showing daily and weekly averages of Production lines. I want to create a weekly chart but I dont want the weekly totals to include the...

worksheet reads January, 2006 but prints out January, 2005. Need to change 2005 to 2006. On page set up it will not let me change. HELP

I use the following formula to calculate the days between 2 dates – =if(or(A1="",B1=""),0,B1-A1 How would the formula look if I wanted to add another column...

I want to have a set of text that has three lines I can't figure out how to add an ASCII New Line Char Tony

I am a new user of excel and I have a spreadsheet I need help with. I have a spreadsheet that has tickets made for an event and I am trying to change the date...

I'm interested in making an Excel 2003 spreadsheet downloadable from the web. I've created a single sheet, single cell (a1 contains "x") and filed it. This...

ANYONE WANT A CHALLENGE? Can anyone help please? I need help from someone who has knowledge about pivot tables and, or, templates. I have a large worksheet...

Hi, Can someone please help me. I am using Vlookup to look up a table and bring nack relevant information. When the information is not found vlookup returns...

Hello Excel experts! I'm working on a spreadsheet of about 50 pages in Excel 2003. Ideally, the client would like each page to have a footer with a number 1,...

I apologize if this has been asked before, but I couldn't find anything with a search. I have a table with monthly revenues. The headings across the top...

Hi all, I have a real lame question about multi-dimensional array operation. Suppose I have defined a two-dimensional array "Array(10,10)". If I want to use...

sample of 2 worksheets for measuring hurricane shutter Sheet 1 a b c d 1 window width heigth ...

I know how to calculate the Average within a range of cells - however, what I would like to do is calculate the average but for only those cells that return a...

i have an apple laptop, and i'm trying to use the 'freeze panes' feature on a spreadsheet. for some reason, when i go to window, the freeze pane option...

I would like to create a workbook where I can click on the cells in row one (the column names) and the workbook will sort the whole row according to the values...

I got help with this in the past. But I need more help. What I need to do is only copy cells in columns A-H if column 24 has an X in it. This is what I have...

I'm trying to put the date in a single cell but another number is popping up when i click enter. How can I get the date to stay and not that other number?

is there a way to give titles to the upper portion of the spreadsheets (that are listed A, B, C, etc.)? also, the same for the left side (1, 2, 3, etc.)?

I am trying to sum numbers using the NOW() function as my criteria, however no luck. sumif($D$1:$BC$1. "=NOW()", D2:BC2) Any help would be...