I have a checklist people use to complete a list of tasks from an excel spreadsheet, and i just have brackets like on the excel sheet. They print it out and...

In excel is I possible to control what is available in a drop down based on the value of another cell? Example If I select EUR in Cell A1 I want the...

In my Excel spreadsheet I am trying to figure out a formula to combine an examiner's initials with a specific date in which a record was audited. For...

I am trying to return a date that is seven days prior to the date I choose, but I want to omit Saturday and Sunday. Therefore if the date of the event is...

I am setting up a class schedule that needs to account for time off during Christmas. The classes all take the same number of work days, but some have a 2...

Is there a way to do a vlookup based on a valid match of 2 values on seperate columns? Example Data..... 3/12/07 3110 23.23 3/13/07 3110 ...

How does the template update with the winners. Do you have to turn on something to get the template to show the winners.

Hi, I am creating 1 spreadsheet from 2 moving sheets using Vlookups. However not all sheets have the same things to look up and returns #n/a - I can change...

I have an excel that has more than 4000 formulas and now i cannot modify data in it. It keeps hanging each time I try to update it. Does anyone know how this...

كي� يمكنني ان اجعل البيانات المدخلة �ي برنامج excel لا تتكرر؟

Hello, Hope someone can help with this! I am exporting content into excel, where alot of the data contains '='. Excel is then using the formula on this data...

Is there any way to have custom ways of summarizing data in a pivot table? I have some grouped values etc, and I want the average for each group and the MAX...

I have trawled through the discussion group and am unable to find the answer to a simple question. I want to change the cell colours of a list if they match...

=IF(M1929.9,G19*5,(N19+O19+P19+R19+S19+T19)*G19) This formula deciphers part time versus full time hours and then adds the rates together; however, I need it...

Hi all, I have one column in which i have data like this A 121 B or 12 A 9 Now i want to separate them in 3 columns A and 121 and B or 12 and A and 9. Any...

I am try to have an if command search a row of data and then print 1 if it matchs and a 0 if it doesn't. However the data is a long string of numbers that...

I like to calculate EMI (Equated monthly installment) for loan terms depending on tenure, rate of interest (fixed) and principal amount. The amount for every...

I'm trying to find out how to have a row that is constantly on screen and is displayed as you scroll down and up. Any help would be great full.

How do i write a formula for the following? I am very close but keep having problems getting it perfect. I've tried so many combos of If(or(and (w/ lookups,...

I'm trying to make a chart of State mandated insurance rates. One column is policy amounts in $500 increments: 10,000, 10,500, 11,000 etc. Another column is...