How do you count distinct names in a range? If a name is repeated in that
range, it should only count it as 1 name. For example:
- Nov 18 Sat 2006 20:10
How do I count distinct names?
- Nov 18 Sat 2006 20:10
Is it possible to make excel NOT process non-numeric cell data in formulae
- Nov 18 Sat 2006 20:10
Trend Line constants as Excel Cell Values
I want to put the constants of a 2 degree polynomial trend line into Excel
Cells. Are there formula's to do this? Equation is Y = Ax(2) Bx C. I want
- Nov 18 Sat 2006 20:10
Convert function
I would like to use this feature, i apparantly do not have it loaded. The
instructions say to quot;load the Analysis ToolPak add-inquot;. I do not know what
- Nov 18 Sat 2006 20:10
Excel: Narrow print area to wrap to 2nd quot;columnquot; on page
If, for example, I have a spreadsheet that is only half a page wide but is
six pages long, I would like to be able to have the group of columns wrap
- Nov 18 Sat 2006 20:10
Stumped on Lookup Function
I would like to display the cell which holds the quot;lastquot; positive number in a
column vector. (in other words...if the vector is a1:a3 with a1=2, a2=1,
- Nov 18 Sat 2006 20:10
How do I import hyperlink data from Access into Excel?
Running Windows XP Pro SP2 and Office 2003 Pro SP2. I have an Access
database table with a field using the hyperlink data type. I want to export
- Nov 18 Sat 2006 20:10
SUM and INDIRECT to reference worksheet
- Nov 18 Sat 2006 20:10
Running macros automatically-AutoFit
I've used Jim Rech's autofit macro for merged cells. It works great. Thanks!
- Nov 18 Sat 2006 20:10
column text merge