Hvordan sætter jeg en andengradsligning op i Excel, så jeg får resultaterne som en graf. Bare det at skrive formlen, giver en masse konflikter. fx X i...

Hi, I need to include a message in the body of an email. I have an Excel file that has a macro button that when clicked will open Lotus Notes email with...

When doing a copy on a single cell I frequently get the error message Cannot empty the Clipboard. Sometimes it repeats several times, other times just...

I have a filtered list of data where one column contains either of two text values say "A" or "B". When using filters on other columns I would like to att a...

I have three named ranges: Name, Status, Name_validation_list. The two first are about 1000 rows long. I need to get a warning if someone tries to enter two...

HELP! is this possible?.. I need a formula, so if a cell shows "Credit Card" then a row appears with areas for the credit card details, but if the cell...

Unfortunately, this function comes back with a 7.5 or FALSE for both Sat and Sun. "ShaneDevenshire" wrote: Hi, =IF(OR(B1="Sat",B1="Sun"),0,7.5) ...

I have a list of numbers, some are 5 digits the others are 6 digits long. For some of the 6 digit numbers there is a complete set, i.e. XXXXX0 through to...

Hi everyone, I have this table running through from page 1 to 10. Title or the header for the table sits on top of the table. e.g. From A3 to I3 I have a...

I know about the formula =SUM(1/COUNTIF(A1:A10,A1:A10)) for counting the number of distinct (text) entries in the range A1:A10 (where there are no...

Skeletor" wrote: I'm sorry to say, this didn't work. But I believe it is due to my lack of understanding, so i ahve a couple of questions; 1)When I...

Hi; I'm having problems filtering data based on the values in a column, I can't seem to get the formula syntax correct. I've given a column of numeric values...

Excel 2003 Have created Sales Order with Drop Down List for Customers (31) and Products (12). Invoice # is automatic as is Date. Workbook has worksheet for...

I created an xls sheet with a column of dates with a chosen format of 12/12/2012. At somepoint in updated the sheet, the format of the date columns has...

Ok the problem starts out simple enough but I want to skip every other row. I am having problems figuring out the formula to use to get it to go every other...

I have a cash flow sheet in excel that I'm trying to create a macro button that will create a new week and delete the current week. i have an old excel doc...

I am writing a macro to automate several processes. I have the following table where column A has positive and negative values and column B is blank. I need a...

Hi Just wondering if anyone can help. I wish to use conditional formatting on a worksheet but cant select it because it is grey. The sheet is not protected?...

in excel, I have various sheets with balances. How do I create a formula that will tie the various sheets into one master sheet instead of having to go back...

Hi - I am trying to find the value of a tiered range of numbers that are in a VLookup table. There are three ranges in the lookup table with a percentage...