Hi Below is a simple example of my data. The bottom shows a table that pulls averages from another table above. Could someone help me create an OFFSET...

What formula can be used to sepearte information in a cell and put into several cells? I exported infromation contained in a pdf file into Excel. In one of...

Why does the FIND("search text", "within text") function return "#VALUE" instead of ZERO (0) when the search text is not in the 'within' string? #VALUE does...

Hi I need some help,please. I need a formula to claculate a value when input A and B are inserted. The table below details the values I am working with and...

I want to sum the difference between each row in 2 columns of data for each case where row(i) in column A 0 and row(i) in column B is less than column A

I would like to create on dropdown box with the state and then a second drop down box display only the counties for the state that was chosen in the first...

Hi all I have been trying to copy some formulas from a tab to another in the same worksheet. what i want to do is to keep the original references of the...

First off, let me say thanks to the Excel Usenet community that has helped me over and over through these newsgroups. You are phenomenal. Question 1: I need...

Hi How do I add (say 13) working days to an existing date? With thanks Ship Shiperton Henethe

My original question dates from 31st July, and was helpfully answered. Unfortunately I am now stuck on a similar problem, which I thought would be easier. I...

I have a need to dump data into a main worksheet and have multiple supplementary worksheets populate their data based on the value in column A. Example:...

I have several sheets, called say Code 1, Code 2 . . . Code 10, each with a table culminating in a total budget figure, which is in the same cell on each...

I need to format a cell to have deg/sec follow when ever a number is entered. I found where in custom formatting there is a +/- sign that is automatically...

im trying to count the amount of times 'Red', blue, black etc is mentioned in colounm K in worksheet 1, as i am entering the formula on a summary sheet. the...

I have a spreadsheet that has a function that manages the maintenance of equipment. when an item goes past a certain date, a box in the same row goes from...

When using the IF statement: IF(logical_test,value_if_true,value_if_false) Is it possible to reverse the syntax? For example, can =IF(A1=1,"very low") be...

Hi I have a work sheet with 20rows and few hundred columns.All the cells has different values and so has different conditional format.the worksheet is...

I need to create a formula for summing cells say B2 through J2 with results in A2 so I use the formula =sum(B2:J2) As you see I am summing 9 cells. What I...

Hi, I posted a question last week and M Kan was helpful. However, I asked further questions and this person has not responded. Can anyone else help me?...