I need help with a formula for percentage of the time kids are in class.... AG37 is Absent AH37 is present AI37 is the percentage of time they are...

Hi Everyone. I'm trying to figure out how to do a formula for the number of times 1 happened in a row starting from a certain date. For example, from A1 I have...

I'm entering a 13 digit number into a cell and instead of displaying the number typed excel converts the number into a formula. Is there a way of turning this...

I have a column in a spreadsheet that consists of dates in dd/mm/yyyy format. I'm trying to write a formula that looks at the dates by row in the colum and if...

I have a cell which I am unable to format. It is a time, eg 7:08. When I select the cell and try to Format Cell, as I scroll throught the different formats...

Do I need some additional stuff ? Thanks

Hi. I'm trying to count a set of #s that is formed by another formula. For example, I have a list of numbers from c1-c6 which all have formulas in the cell...

Hi I'm having trouble inserting rows automatically when using the "get external data" in excel. The problem is that the data I am attempting to insert has too...

I am doing an online school project that requires using the "Regress interface". I cannot seem to find it. The directions I received from my instructor said...

I am working on a spreasheet in excel I have got invoice numbers but i need to create a warning for repeated invoice numbers.Any help would be...

My work sheets keep growing larger even though nothing is entered into the cells. How can I maintain the work area I want with an error making my workbook grow...

Well, I just created my very first userform. Wow, how cool is that. Anyways, I was wondering if anyone has a suggestion for storing userforms and macros in a...

Hi, could someone please tell me how to 'lock' a column in an excel chart? I am using Office XP (2002) on Windows XP Pro SP2. I downloaded a template from...

Hi, I have data in Excel file and I have linked to data in some other Excel File. Whenever I opened file I will not get automatically updated the links,...

I have an excel worksheet containing a list of userid's in cell A, for each row I want to reference the userid in cell A and connect to an external Oracle...

Hi all, In row 2 I have dates, E2 contains April 4 2005, F2 April 5 2005, G2 April 6 2005 etc. In A4 to A40 I have names and in E4 to CR40 I have an entry...

I am trying to add alpha and numerical together. Basically if there are any alpha characters in a column then deduct them from the total number of all the...

Hi NG, Here is a small example of a problem I cannot solve: 3 columns a b c x 2 y 1 z 4 x 5 * p 1 q 6

when creating some code, via the record macro function I find that sometimes, for it to run succesfully, I need to add "Application" immediately before some of...

I have compiled this makro. But the error message is:Compile error invalid or unqualified reference and CheckBoxes is highlighted. Please help. If...