Just wanted to know if there is a Formula that can count DIFFEREN
names
in a Column?
eg.

i am currently using the correlation formula to test on a large set of
data:
e.g.
CORREL(IGR!C233:C262,IIA!C233:C262)

Is there a way to put a check in the spreadsheet?

I have an Excel table full of information for a certain number of
individuals.  I've created a macro to reorganize, transpose, and arrange the
data that works beautifully for information for two individuals.  However,
the number of individuals whose information is in the table ...

Hi ther guyz............i a have small problem with the execl
sheets...........
my problem is e.g. i have alot of cells with a number and some text in
it........and they both are in one/single cell (e.g. "878 queen st" in

I am creating a pivot table that measure the time to place a case using
DateReceived and Date Approved.  The TimeToPlace would be by pivot and
I want to have grouping of 15 like so:
0-15 days

Sorry if this has been answered before but I can’t find it anywhere.
In column 1 I have a list of products code I sell.
In column 2 I have my buy price.
In column 3 I have all the products supplied by my supplier.

Hi, im having a little hard time here, id like to know if this can be
done.  i have data sorted like this:
         Col1        col2    col3
R1       a2             b5      r9

I have a serveral lines of VB that I need to Concatate, I have them in
seperate columns b/c a few aspects will change.  Currently my
Concatenation looks like =H2&I2&J2&K2, I need a carriage return between
&, I can get this result by putting each row colum on a seperate row,

I need to set up an excel worksheet where the data in the "Cost" colum
is added up to show "Total Cost" at the bottom of the column. I can d
this very easily for a static range but the "cost" column is no
static, it will keep on growing. How do I write a formula for "Tota

I have the following two arrays
A        B
0.656762726    0.502636772
0.607062936    0.358819486

Is it true that under all circumstances I must sort the array table in
**ascending** order so that VLOOKUP  will return the proper values?  Is it
only necessary when I deal with ranges, say minimum score and a grade?
Appreciate explanation.

Is there any quick way to get a distinct list of unsorted (or sorted if
necessary) column with repeated values?
Thanks.

How do I apply the general number format "0.00" to the selection using
shortcut keys?
Can't find it via the help feature.
Thanks.

I need to format a column so that all cell force any text entry to
uppercase. I've looked into the UPPER() function, but that is something that
would actually take the value from some otther location and display it in
uppercase where the fuction is located, which will not work.