C
Craig Brandt
Hi Guys:
There is probably no way to beat this, but it's worth a try.
I am downloading a list and if count this list with the following formula it
gives me what I would expect.
Column A = 285 names (contiguious) (Starts in row 2)
Formula =COUNTA(A:A)
gives me 285
Because this list includes a lot of repeats and I am interested in a count
of unique names, I sort the list.
Then in column B(B2) I insert the formula =IF(A1=A2,"",A2) and copy it down.
This gives me a list with lots of holes where the repeat name occur.
I use the formula: = COUNTA(B:B) and expected a number much less then 285,
nope 285.
Thinking that the COUNTA was counting the formula, I copy and paste as
values. Still 285.
If I select a blank cell and "delete", the count decrements.
Is there a simple solution that will enable me to get the results that I am
looking for?
Craig
There is probably no way to beat this, but it's worth a try.
I am downloading a list and if count this list with the following formula it
gives me what I would expect.
Column A = 285 names (contiguious) (Starts in row 2)
Formula =COUNTA(A:A)
gives me 285
Because this list includes a lot of repeats and I am interested in a count
of unique names, I sort the list.
Then in column B(B2) I insert the formula =IF(A1=A2,"",A2) and copy it down.
This gives me a list with lots of holes where the repeat name occur.
I use the formula: = COUNTA(B:B) and expected a number much less then 285,
nope 285.
Thinking that the COUNTA was counting the formula, I copy and paste as
values. Still 285.
If I select a blank cell and "delete", the count decrements.
Is there a simple solution that will enable me to get the results that I am
looking for?
Craig