I like to have the margins as far left and right as possible and the top and bottom margins just enough to put the time/date and file name in the footer. How...

I'm hoping this is easy but could someone please help me with a formula? I'm trying to compare a date with today's date and if the dates are more than 90...

I am trying to average a column of numbers. I want to only average the cells that contain a number greater than 0. How do I do that?

No matter how much I use the delete function, my worksheet is convinced it has 65,000 rows. This takes up memory and is a pain to navigate. How do I get...

I have a situation where there are 6 colums with data in each row: V, 02, BA,1,3,R When I concatenate this, the result drops the 0 preceding the 2 and gives...

A B 1 Right femoral Angioseal 2 Left Femoral ...

I have used conditional formatting with a formula is statement to highlights cells in a column of about 5800 rows. Now that certain cells are highlighted...

I am pretty sure that this is possible but can't quite figure out how to do it and am not very literate in Excel. Here is my problem. I am importing data...

Is there a way in Excel to temporaraly hide a column or temporarly move a paragraph up within the column without affecting the column next to it or above it?

Does anyone know why I would get an error of " #name? " when using the weeknum function. =weeknum(a3,1) was used on a date field to attempt to get the...

my apologies if a similar question is already here, but i could find it that quickly. i need to lookup a value in the following situation a b c d e f 1 ...

I have a SUMPRODUCT formula that I know is OK but returns the answer 00:00:00 =SUMPRODUCT(--(Sheet2!B4:B573=A6),(Sheet2!C4:C573)) Sheet 2 is full of cells...

How would I write this IF statement: If C2 begins with 4 put "P", if C2 begins with 7 put "S", otherwise put nothing? Thank you so much. Connie

I have Dealer#, DealerName, DateFunded(January 03, 2007), Amt. Funded and RepName, I want to be able to write a formula to show me how many deals were funded...

Hi all, I have a list of categories to indicate employee disciplines, i.e Management Electrical Mechanical Other and so on. I have other cells within my...

Hello, I use Office 2007; i made a combination between an Excel file and a Word one. My problem: After i realised this joining, in Word, the numbers appear...

I want to use a function to do determine the number of Yes and No Answers to different questions from different departments. For example, here is a...

hello everybody, I have been tried to use a chip pearson code http://www.cpearson.com/excel/SortByColor.htm but it doesn't work on my 2003...

Hi My last posting I had asked for help and when I used the formula they gave me, I had said that it did not work. I did send another message to say that...

I can not insert subtotals into a table but the book says I should be able to?