My excel's formula is not currently funtioning automatically. An example is when I'm copying a formula to be pasted in multiple cells either any direction,...

I'm making a 5 page doc that will be used 2 times a week. I need to put the date on each page and would like to type it once on the first page and then have...

I have to maintain our representative database & send it to our head office lilke A B C D ...

I am using a pivot table to control a list that needs to be updated frequently and feeds into a complex series of workbooks. Each individual adds their own...

I would like to create a function that I would copy down column H and I that would take data from every second column i.e. A, C, D and then put it all into...

I often am able to set up my excel tables in advance - Borders, bold or italic cells, etc. and then later when the data is available I often am copying and...

I am trying to write a formula looking at the last value of an number, and if that number equals a certain value, copy a different reference cell into a new...

I am working with a spreadsheet that uses the conditional statement as follows: =IF(C7=9999,0,(+B7-A7)*24). The forumla works fine when B7 and A7 have data...

Hope someone can help with this, I have a workbook allocating men to machines. The details are in a range 3Cx9R for each rota and there are 9 variations of the...

Hi, I have been trying to figure out a way to use the sumif with 2 criteria & 2 ranges...here is what it looks like Name Job Name Class Amount Lee...

Good afternoon I have a situation where I need to assign a zone number to a order number based on where the order is originating. In my situation I am...

i am creating a entry form for an event. there are checkboxes throughout that have a value connected to each. when a checkbox is chosen, i need the...

How to apply a bracket to right side of a series of text cells?

Hello, I am trying to create a formula that will give three possible results for a result in another cell. The answer in cell C1 may be 4. Then in cell D1...

Is there a way to use a drop down box in a cell but not have it priint the box just the value selected?

I have a spreadsheet with two columns that I want to check the values in both to see if totals agree.. I have place this in as a forumla but comes back with...

I am trying to pull the result of a drop down box into another cell so it does not have to be retyped later in the worksheet. Any help will be appreciated.

Say i want to auto filter a file that has 10 columns of data. I want to filter by three -five different columns and i want to calculate the median, max, and...

I've imported a file and I need to put the data in columns. The data seems merged.

In a calculated field in a pivot table, , this produces a #VALUE in areas where in there is no(blank) data to calculate. (IOW, 'Total Sales Item Amt' can have...