I am getting a peculiar result when using the formula below to sum up unique valus in a database. The formula in AD3...

I need an excel formula which claculates 'between' 95% and 100% i.e. If( O2= between 95% and 100%, 1 x 2, 2 x 3) I need nested IF functions,

I have to figure out the impact if a daily salary increases. How do you calculate the difference ex: $100/day to $200/day, what is the impact on annual...

Hi, I saw a few formulas that adds Unique records when is numbers, but I have a spreasheet which I need to count the Unique records (Names) taken into...

I am working in an Excel 2007 spreadsheet and one very long column of normal numbers are not sorting. for Example: 407 408 102 103 104 Everytime I try to...

I'm trying to create a table where users can't edit the content of the cells but can edit the ordering of the table- what's the best way to achieve this?

Hi, I have two series of data as follows: Distance Height 0 0 6 12.5 11 23 12 16.25 14 26.75

Hi Struggling with this indirect formula - got #ref error exel 2003 A4 = sheet number =SUM(INDIRECT("&A4&!"&M1:M14)) any one able to assist?

Hi Wonder if you can help as i cant get my head around this. I have tried to use a combination of match, index, vlookup but just cant get the combination...

Hi guys, am sure you'll be able to help with this but I just cant figure it out; Worksheet looks a little like this; A P ...

I have data which has come from PeopleSoft. One file is a list of current employees (about 4,500 rows) including a unique ID and I am looking up their date...

-- How do I find the minimum value in a range while ignoring any zeros in that range using Excel 2007?

I'm trying to create a formula that takes into account two columns B & C and matches those two coloums with two columns from another table in A & B and if...

I have a worksheet where I track what I've applied the number to; i.e. acct # in column A and user type in column E (nanny, sitter). I'd like to use a...

I have a workbook for product sales data. each sheet in the workbook contains data for different product and inside each sheet, salespersons and their data...

In one sheet, have a column with a street number (A): 115 in Column B, have a street name: Northwest. In workbook 2, have an additional street number...

I am trying to write a formula using the ISNA for finding the name to an ID. In Sheet 1 cell E2, I tried the following...

I have the following formula in cell A9: ="NDTMTASME001Q-"&BC69&"-"&AG13 which returns: NDTMTASME001Q-40273-1626, however, the 40273 is not correct. I...

I have an excel spread sheet which includes a graph I made from the spreadsheet. I would like to copy both to a word document but I don't want any reference...

I would like to use VLOOKUP to copy a hyperlink from another spreadsheet. Is this possible? Currently, when I do the VLOOKUP, it only copies the display...