I am trying to return a value from two different worksheets using a unique string attached to each rows on those two tables. Here is my logic : If my unique...

I am trying to put a worksheet together for a client that I need help with. The objective is to have all of the calculations set up for the client so that...

I have a master sheet that has a table with rows of data. The first 3 columns of each row contain information that categorizes the rest of the data in the...

Is there a formula to identify missing numbers in a list of consecutive numbers? -- Peace squared

Hi, I have a worksheet using an autofilter and I need to get the value of the previous visible cell once the filter is applied. Assuming my formula is in...

Hey everyone, Excel 2000 I have a range of cells like so (each number is in it's own cell) 50 20 30 60 90 30 The FIRST cell (in this case, "50") is...

Excel 2003 - I have a VLOOKUP formula which I have copied down the column. When I check the formula it has copied down correctly, yet the result returned is...

Inm a test I am asked to insert a wordart onto an excel Spreadsheet, then move the wordart and position it behind the data. I click send to back but it...

Hello I've got a series of exisiting workbooks: Rota2008.07.21.xls, Rota2008.07.28 and there are some which WILL exist: Rota2008.08.04, Rota2008.08.11, etc. ...

Does anyone know if a listing exists that shows in what version a particular function was added to Excel / VBA? For example: in which release did SumProduct...

What function can I use to convert a decimal number to a time number?? For example, The decimal number "1.50" would mean 1 HOUR 30 MINUTES. 1.25 would mean...

Hi everyone, Column B contains a list of text data, which happens to be numbers (e.g. 1172, 4721, 6743, etc.). Every time I enter a new number in the column,...

1 2 a 4 b 2 a 4 c 3 b 4 For the above example, I would like a formula that can count how many times "a" appears in column 1 with "4" in column 2...

A little background...The data is in Worksheet1 and I want to show the results in Worksheet2. Column A=Month, Column B=Date mm/dd/yyyy format. I want to...

Jeg er ved at oprettte dagsedler for mine ansatte og vil gerne have mulighed for at tildele hver enkelt Sheet et fortløbende nummer som bliver påført hver...

I have a worksheet with lots of data and I need to combine some data into cells using a check of adjacent cells. Sample: column ...

I have a vLookup formula that is looking at a worksheet in a multiworksheet workbook. I wanted to delete the worksheet and have it create the worksheet via...

I have created a protected sheet with a few pre-populated, unlocked data entry cells. Is there a way to create a Conditional Format to "highlight" the...

I have downloaded abot 20,000 lines of data. One of the columns in the data is a date field. The dates begin in 2004 and continue through 2008. The dates in...

I have a task spreadsheet. When my task changes to complete I want to pull to another sheet and hide it's view from the main sheet. Does anyone have any...