I have a two rows of labels but the second row of labels I want them in one column not across as a column heading as I am using the column headings for...

Dear All, I am preparing a compartive statement i want to highlight the max and min a group of cells. quote-1 quote-2 quote-3 100 150 200 like this upto...

hello all ! can anybody show me the right syntax for this.. ='Sheet1'! & D14 & 100 ...so it could be for example... the cell L100 or BR100.. it...

I have several entries (formatted as text) for example, :31, 1:04, 4:53, 23:34. These numbers indicate minutes and seconds (31 seconds, 1 hour 4 seconds,...

Could you help me in sorting numbers. In column c I have the following numbers and it sorts it like this. 03 11 113 12 15 30 303

HELP! Greetings from Bermuda! I have referenced a cell in another worksheet that is using autofit row height. I want the cell that I am pulling the data...

How do I average a range of numbers between two criteria? For instance, I'd want to average only numbers greater than 5 and less than 15.

I have some data I need to have returned if it matches something else. The data pictured below is in worksheet 2. In cell A2 of worksheet 1 is 153. The...

I'm trying to understand how/why this works... =OFFSET(A12,MATCH(MAX(E12:E300),E12:E300,0)-1,) So the reference cell is a12 - got that Understand the...

Is it possible to format a cell / row so that if the text in a cell is longer than the width the text wraps and the row height expands to include the extra...

I have two worksheets in different workbooks, one as a master list, and the other as a sub list, with candidates names and information (I'm in Human...

I have a known future value = $300,000 worth of stock options in year 2012. A third of this value $100,000 will vest on 12/31/2010. A third of this value...

I'm trying to set up an Excel workbook with a dynamic link to an Access database containing quality data, involving dates. I want the workbook to always...

I'm currently using excel 2003 and am trying to figure out how to update multiple worksheets within the same workbook by just inputting data into one sheet....

I have a rate chart which covers different values, such as: If the rate is between 32.00 and 33.99 then the cost is multiplied by 38% (1.38). If the rate is...

I have been trying forever and no luck at all!!! I have changed the the whole column under format cell/Number/Category/time and selected 13:30 (english USA)...

Why don't 2010 posts come up in search? I know this isn't actually about excel - but excel is what I usually post about and I don't see a place to ask about...

I have this request where it is taking several locations and eight different metrics but weighting them differently depending on their category to get an...

Hi all, Fourth try's a charm....I'm getting errors trying to post my question. Here it is... 1 workbook, 4 worksheets each named for a different...

I have a Lexmark printer which is set by default to print 2-sided in the printer properties. However, if I print a workbook containing several worksheets to...