I'm trying to write a formula that will count a cell if it has a certain fill color. For example, I have a range of cells, A1:A3, where A1 & A2 are filled with...

I have a spreadsheet with 8 years worth of data in col months. For example row5 Col's C through CF have dates starting with the first day of the month, like...

Hello All, I am creating a scheduling workbook with 2 work sheets, the first sheet is the schedule itself and the second is the availability. When a staff...

I have a file from the Australian Bureau of Statistics which is in excel, but is ASCII comma delimited. None of the usual excel functions will recognise...

How can I use @pmt function to calculate monthly payment when first payment is something other than 1 month (ie 45 days). Please e-mail me.

Hi Howard, There are several ways to do this depending on how many variables there are. Here's one way: =CHOOSE(A1,400,375,325) Whatever number you enter in...

Hi, In the Community NewsGroups why i am unable to see the updated information. The last question i can see is the one posted on 17th Sep 2003 10.34pm. Till...

How do I extract data from another worksheet with the same ID? E.g. (Column A will contain the ID and column B will contain the quantity) Worksheet 1 A5 -...

Hi All :-) I am trying to create a formula. A1=(B1*C1) OR (D1*E1) B2=(A2/C2) OR (D2/E2) C3=(A3/B3) OR (E3/D3) I wish firstly to lock cells A1,B2 & C3 as to...

I need to change the date format from 31/8/2003 to 8/31/2003. Could some one help? Under format, I tried changing it but it goes to an incorrect date. Paul

I'm converting a spreadsheet from Works to Excel. I have two questions: 1) Is it possible to name the columns? e.g. name, date, etc. instead of...

I am trying to find a formula to give a collum of "X"s,"Ph"s,and"*"s,a value of 1 for each, the collum is L6:L168 The total would show in cell L177 I don't...

Hi D2=IF(A2="","",IF(C2="G",B2,NOW())-A2) and copy it down as much as you do need. When the started call is closed, B-A is calculated; When the started call...

"daredelsol" wrote in message ... Hello. I have two VLOOKUP formulas that give the...

I am trying to sort a section of a worksheet which contains the values of other cells. i.e Cell C3 contains the value of Cell A1 (=A1) Cell C4 contains the...

I am using a workbook (30 worksheets), created by someone else, that contains macros (A message appears everytime I open the book that asks for me to enable or...

Hello: I have problem on how to calculate the daily average! Would you mind to give me some hints? Raw Data format! "Time","Free Megabytes" "08/01/2003...

Columns of numeric grades are to be averaged, but teacher wants to choose where quarter averaging begins and ends. I want to just have them enter...

How do you delete old links that do not exist in a current work sheet?

I was working in Excel on a completed spreadsheet, hiding some data preparing to do a mail merge. I had to close the program due to someone else using my...