Hi, Before i start let me tell you that I am completely new to Excel, so please forgive if i am asking the obvious. Until today i thought that I can manage...

I have an excel s/s which shows in one column a reading of a central heating gas usage , In an adjacent column I want it to automatically show the increment in...

Hey All, I am working on a spreadsheet that I would like to have it append the inch symbol as part of the number format ("). I figured out that I can add...

I will try to make this as simple as possible. I have an Excel worksheet for the year 2008 and among the data, there are closed and finished accounts. If I...

How do I pretect sheets in such a way that users can input data but can't change formulas, macros etc? Thanks John

I need to calculate hours per thousand. Can someone give me the formula to...

Hi, I have two columns of data, 5 students and their grades in columns, say B (name) and C (Grade). How can I reproduce the highest grade and corresponding...

Is it possible to make the excel IF function give me the result of a mathematical calculation as an output?

Hi-Have several columns across, one being a date column. I have a BOGO (buy one get one free program). The date column is left blank until that item is...

Hey, I'm having these (hopefully simple problems) with writing in page numbers: 1. I want to write ex. "7-19" in a cell - Then in another cell I want excel to...

I have a spreadsheet that has a column and the contents of the column is either a "Y" or "N" I would like to know how to count (sum) the number of "Y"'s and...

I have a worksheet that contains several columns of data that I want to sort and/or compute figures. I have figured out how to accomplish everything except...

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...

Okay, Forgive me ahead of time, I really don't know much about Excel. I can work with templates and create simple formulas but alot of what I read here comes...

I'm using Excel 2003. I can create columns, rows, data, new worksheets, etc., so I have a very basic knowledge of using Excel. With that said, here is what...

Hello, Thanks for previous help; really appreciate it. Two questions, please: a. Copied a column of frequencies from a radio database into Excel...

hi hope someone can help, i have a spreadsheet that has daily sales, monthly sales and yearly sales which (forgive my explanation i am a complete newbie lol)...

Hi there, I want to click on a button (created from form), then the print window appear. I did the following steps: created a button; recorded new macro; File...

Hi Group, I am using Excel for the first time and have 2 questions. 1. I have created a spreadsheet that includes some blank rows. Is there a way to add...

Hi all..could you please help me with the following formula? =if(weekday(B2-1)=1,B2-3,B2-1) B2 is 7/31/2008. I'm very new at excel, please forgive my lack of...