I'm trying to find the difference of two columns of data (only on the subtotal row) created with a pivot table, instead of the "total" that the table gives...

I am creating a simple spreadsheet which pulls data from another. The first (diary) has the names of operatives and the job numbers where they are working,...

Hi, I have read a post on here with the same subject from December '06 but what I'm after is a bit different and I don't want to populate all cells in the...

How to update a DGET function value without opening the source document. So far only have this problem with DGET. Office 2003

Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry

struggling here

I WOULD LIKE TO SORT UPC, ALL IN ONE COLUMN, SO THAT ONLY UPC S WITH THE SAME ONES WOULD BE...

Using F2 and F9, I am able to remove a formula from a cell, but how can I do it for an entire column of numbers? Tks, mr

I'm in need of desperate help with this one. I need to add the total of column B based on the information in column C. Cells C21 to C46 each reference a list...

I have written a formula that may return "n/a" or a number. If it is a number, there are 3 conditional format colors that can occur if the number is within...

I have selected a range of cells in a row and created a rule to change text color if conditions are met. I have multiple rows to which I wish to apply this...

Hi I need to work out the difference between todays date and a previous date, but I want the answer in this format: Years & Months & Days Is this possible?...

Good afternoon, this is not a homework question, I am trying to brush up on statistics for my job. I am having a problem with a question. A 4 year college will...

Hello, First of all, take a look a this picture, it will help when you're answering my question. It's a screenshot of what we're working...

I am creating a workbook that contains multiple sheets. I want certain sheets to be hidden once the workbook opens. Then I want the user to be able to...

Hi I am working on stock workbook each item has a reference the first sheet is the main sheet with all the reference numbers and their name the other sheets...

Hello, I need to know how to compute the APR for a mortgage quote using the following data: Rate: Say 6.75% Term: 360 months Loan Amount: Say...

I have a database that is sorted and imported into excel for charting purposes. I have all the data there but need to pull out the first 2 numbers of a field...

Hello all i have a couple of workbooks that are copies of each other. i need to merge them. it seems that you have to share the workbook before this function...

I have a major formula that I'm trying to figure out and I needed some help. Column A= ID#s Column B= Status Column C= End dates Column D=Responses Column D...