If there are no blanks, use the infamous g Dave Hager formula to count the number of unique items is a range: =SUM(1/COUNTIF(A2:A9999,A2:A9999)) entered as...

I am wanting to subtract years of service & drag the formula on a worksheet. I have 01/01/2003 (cell H10)in one cell. The formula to subtract in cell H11 is...

Hi, I want to copy my conditional formating from one cell to another but it's not doing it the "right" way... The condition looks at one cell value and then...

Is there an 'easy' way to accomplish outline numbering similar to functionality in Word? I haven't found a built- in tool or feature, but I'm wondering if...

Hi, I have a workbook with two worksheets. Each worksheet has a form I devised. I'd like to limit the user to print only one of each form. Is this...

I want to insert specific data (if s,v,or ss is in range b4 to b25 insert corisponding name from column a4 to a25) from an excel workbook into an outlook...

"Oleg" wrote in message ... How to divide the text data ??? e.g. In a cell A1...

An if statement can only contain 7 nested functions. How do I get around this restriction?

TIA for any help. Conditional formatting requires that any range referred to in a condition formula is located on the same sheet. Is there a way to refer to a...

Thanks for looking at this post. I noticed that if I set up a defined name for a range on one worksheet (say 'Sheet 1'!A1:D50) and call it JanData03, whenever...

We have recently converted from Office 2000 to Office 2003. In Excel, say you have a list of numbers down a column, with an autosum at the end to add all the...

I have a table that I would like to retrieve data from by using two different user inputs to specify the values in the start of the columns and rows. I want...

Does anyone know if it's possible to find the TWO minimum values in a range? I know how to use MIN to find the first, but is there any way to find a second...

I have a long spreadsheet where I have already inserted many names with numbers in column A. I would like to move the numbers into a new column B, and leave...

I have a range where i would like to copy every 8th line and ignore the 7 blank lines inbetween, now how would i copy one line of formulae to read from Sheet1...

I will be putting data in an Excel worksheet Each row will have a calculate value which has a color assigned to it. This data will come from MS...

Is it possible to do a distinct count within a pivot table?

I need to subtract 7% from a number. I am using F4*(1-7%)and I am not getting the right answer. Please help.

I'm trying to set up several formulas that calculate totals based on ranges/arrays so that they can be copied to adjacent columns without someone having to...

Let A2:F100 be the area (including the labels) where you apply...