Hello, I'm getting a #REF! error with your formula (my original message and your response is below. I have assumed that Patterns is a name which refers to...

I have a spreadsheet with a list of buy prices on, however we buy from different countries so therefore all of the buy prices are in different currencies. I...

Hello all, I have an Excel spreadsheet with a header that contains the exact same 30 names as the corresponding 30 fields in an Access DB table, and Row 2...

How do I format a cell to not show 0 as being negative? Could it be the formula I'm using? This is the formula in cell L321 ...

Hi, I will try my best to explain. I need to have conditional formatting as such: 3 cells in adjacent columns. first has name, second has text missed...

In excell worksheet there is a cell named: Total Sales which requires data from Access sales data sales which has the report/form if we run can produce the...

On sheet1 I have the following data: A B 111 NAME_1 222 NAME_2 333 NAME_3 444 NAME_4 .... ...

Problem 1: Rate of Interest (ROI): 7.50% - Compounded Quarterly Annual Rate Compounded: =FV(7.50%/4,4,0,-1)-1 ie 0.0771 Minimum Investment=Rs. 10 per...

I have a spreadsheet of UNC drive mappings. I need to extract out just the name of the server from the fields. Example: \\SERVER01\user \\SRV02\user I need...

I have a sheet that when protected, greys out the decimal place setting buttons up top of the sheet on the menus. Is there a way of having the decimal place...

I tried the following two formulas, which should be producing the same value, but I either get a blank cell or N/A. I have copied this formula and am...

I have a 3 column table which looks like the following A1..5 B1...2.0 C1 8.0 A2..12 B2...3.25 C2 11.0 A3..16 B3...4.65 C3 15.5 I would like to input...

I want to move cells from one page to another by using a formula, or basically without having to manually enter then numbers. I am sure there is an easy way to...

Hi, I have few rows which are alphanumeric cells, I need to extract only the numbers from the cell. For Eg: One cell contains...

I am running Excel 2003 SP2 and have been trying to figure this out for 2 days. I have reviewed all of he postings and cannot get this to work. I have a 4...

I am trying to write a spreadsheet for tracking man-hours worked over a pay period. What I want to do is sum the fields for the first week, and if the total...

I have one spreadsheet that contains 6 or 7 Queries that are all directed toward the same data source "MB7 data - 2006". These were needed to pull figures...

I need to create what I would think would be an IF formula for quite a large group of measurements. Here is an example of what I am working with... A ...

Hi, I have two tabs in workbook Tab "Blank" which contains a table with two columns "A" & "B" and rows "42:69." In column A you place an "x" to signify the...

how do i get the count if function to count based on certain concrete conditions...if cell a1 = condition a and = condition b then add 1 to count...