automatic adjustment

Item Name Fixed Price Lube Oil Qty1: 549, Qty2:999, Qty 3: 1399, Qty 4: 1699, Qty 5: Dcapsules Balancing Figure of Total Order Value, ABCD1Order...

Hi I have a peculiar problem while using VLOOKUP The issue at hand is this 1)There are two sheets say Sheet 1 and Sheet 2 2)Now I have to look up variable in Row A2 in Sheet 1 for a given date in a specified range in Sheet 2. 3)So I do a this action for eg vlookup($A1...

Hello Everybody, First of all, thank you so much for using your time in assisting me with this matter and reading this inquiry. It is greatly appreciated! I am currently making an order form in Excel, where I am pulling my product data (material description) from a sheet I have named...

I could use some help with this formula: =(SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B11:K11"),"<>"))) This formula is counting the amount of times a value appears in cells B11:K11. The cells A32:A34 refer to the names of different worksheets – Week 1, Week 2 and Week 3. The formula itself...

Hi there, I have a searched through the forums, and may be searching via the wrong words, but am having challenges putting together probably a relatively simple formula. I need Excel to automatically update a numbered column when a cell may be deleted or changed to alternative text, for...

I'm trying to make a spreadsheet to rank the shows I've watched. I have a chart where they can be sorted alphabetically, by my score, by the date I watched them, the amount of episodes, etc. That's already been done...however, I wanted to also sort them by my rank preference. Say I have 3...

Hi there, I am a teacher at a high school and am currently creating an Excel workbook to record students who need learning adjustments made. On the table I have various columns of data, with student names listed in column B with their CURRENT year level in column A. I’m not sure this...

Hi everyone, I've been learning a lot about excel recently from this site while working on a large database of comparative linguistics. I am basically writing out the IPA (phonetic spelling) of a number of different words, for a number of different languages. My spreadsheet looks like this...

Hi i have a recent problem with excel, when I enter a whole number with no decimal point, it automaticly moves the decimal point two spaces. I have un-instaled and re-instaled excel in my mac, but it keeps doing it. Example if I enter 5, it shows .05 if i enter 100, it shows 1.00 but if i...

I would like to have one sheet in an Excel workbook(B) be tied to another workbook(A). Thus, whenever I make changes to Workbook A, the worksheet in Workbook B automatically updates with those changes. Is this possible in Excel 2010?

Let me give some background informaiton on the project I am working on. I work for a construction company and we are doing work in a hospital, where we must keep airborne particles to a minimum. We collect data at 8 separate locations, 4 times a day. For each location, we take 5 readings per...

I have a question about automatic adjustment of the X-axis in a graph. I have drawn a graph of NPV with a X-axis of time in years, which is 1 to 40. I have a input cell where I can set the Life expectancy of the project (e.g. 25). Is it possible to have excel change the x-axis depending on...