hello im working on a spreadsheet with rows of data that need to be dragged and dropped to various categories. each category has it's own subtotal. if i...

Hi, I have a ratesheet in excel like e.g. Carrier FromDate ToDate Rate A 01.02.10. 28.02.10. 100 A 01.01.10. 14.01.10. 99 A ...

I am trying to autofil certain colors to rows that have dropdown choices. Each choice will be assigned a certain color.

I would like cells to be filled with specific colors when an IF formula results are true. Is this possible?

I need to know what Excel Formula helps find duplicate records and then removes or hides them.

There are many occasions when I would like to number the line items in the far left column of the spreadsheet I am working on, so that the numbers print (the...

I have two spreadsheets that I need to merge together. They don't share 100% common data, but they have one column of data in common. Anyone know how I can...

I have a large source of data which is laid out vertically, and I wish to put it into a format which allows Outlook to import and use in a mail...

This is probably not possible, but I figure there's not harm in asking. I know that if I have a cell containing "apples and oranges" and I highlight "apples"...

I didn't know where to ask. It would be easier to attach a worksheet to show the problem. Please point me in the right direction if someone could please. 1)...

I would like to auto fill the following formula ex: A1*B1, A2*B1, A3*B1. The auto Fill automatically changes the B column with the same number as the A. Is...

I have a range of N cells, all in one column and all unique numbers. I also know that Z cells from this range adds up to a number R. This combination of Z...

hello, perhaps somebody knows how to do this: in column A i have different values, for example: A B 1 aa 2 bb 3 cc

For some reason the --(Input!$K$2:$K$1000=$J$18), Criteria doesn't work? I've used the following...

does anybody reccomend any add-in and/or best practice to grapple with long command statements ? All the best, Alex

I am using the following array formula which seems to only work for most of the records. I don't use array formulas much and was wondering if there are some...

In 1 sheet I have an account register as it appears in a checkbook: Date, Payee, Classification, Debit, Credit, Balance In sheet 2 I have columns designated...

Hello everyone, I was wondering if there was a way of excluding Zero’s from averages. I have tried IF and AND but have not been able to get it to work...

I have the list of equipment in the column A and amounts in the columnB in the closed book as follow: ColumnA ColumnB F 10 B #1 ...

TransferSpreadsheet to colored fields Hello, I have an MS Access file that transfers data to Excel using the TransferSpreadsheet method… It works fine, but...