I need to take a number in A1 (inventory) and divide it by the networkdays for each month. A1 would represent Jan, B1 Feb...... The formulas would be in A2,...

I am trying to write a vlookup that looks in more than one column for the data, is this possible? Col a Col b Col c col d 1 a ...

using office 2003 with analysis pak installed. weeknum working fine then come back few hours later to #NAME, analysis pak still installed but weeknum now...

Hi, I need to do the following and have tried with a vlook up and nested if but does not seem to be working. I have two sheets and I need to look up a value...

Good day, I have a tally sheet that can be used to manually enter data in cell D18, but in most cases it will be automatically be populated from a previous...

I am trying to use a cell reference within an array, but Excel won't let me. In my case, here is the formula I want: =IRR(A8,50,50,50,50) A8 is a negative...

Hello, I am trying to get the rows to change colour on my spreadsheet if certain criteria is met. The range of the spread sheet is A4 to T4 annd wal down to...

I have created the following formula:- =COUNTIF(Sheet1!A3:A7,$A$2) What I would like to do is create a countif formula looks in different sheets (but at the...

Hi, I have a spreadsheet that tracks the entry in a particular cell in a number of other spreadsheets in the same workbook i.e. Cell A1 contains "=Jun09!$X$1"...

The data in workbook A is updated using formulas using the data in workbook B. Can we count the specific words/letters in the row where the data is imported...

Hi All, I have a worksheet with a data table (from an ODBC source) which I want to calculate values based on the ODBC query results, the problem is the fill...

I have created a spreadsheet with a formula which takes information from other cells to enter the appropriate result which is fine. My problem is that some...

Dear all, Please find the attached demo file. On the summary page Cell B5,there is a sum function which is linked to first three pages.i just want to extend...

In a index or match function if I have almost 40 characters it does not give me the values am looking for. Is there a limit on the characters? if Yes, then...

St M(Lean)/M(Med.)/M(High) Veg Frt Mlk Fat GOALS CALS PERCENT CAR: 1,000 50.0% PRO: 400 20.0% FAT: 600...

Stay with me, not a very good techical writer, will try to be clear. I get a daily Excel spreadsheet with multiple columns. Would like to set up a new...

Press F1 and look up the Excel Help files on the TRANSPOSE feature. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES...

This is what I would like to achieve. From the moment when I enter a data in cell I would like that text to stay red for number of days, and after that...

I have entered this statement =SUM(IF(DataEntry!$O38=$A$1,DataEntry!F38)). I know that it is correct as it is returning the correct infromation. the...

Hello - I have a number in one cell (D2) that I need to use as a constant value (in the denominator) to create proportions (E2/D2, F2/D2, G2/D2, etc..)...