Assuming the data occupies A2:A100

=SUM(1/COUNTIF(A2:A100,A2:A100))

entered as an array formula with CTRL+SHIFT+ENTER.



On Thu, 17 Feb 2005 14:45:03 -0800, "ChelleA"
wrote:

I have a listing of proceedures for each patient. But I want to summarize
the number of patients with out having to manually have to go in and count.
Is there a formula, or function that can do this?
Example:
column A column B column C
Patient number Proceedure number proceedure date
4455 152 1/1/05
4455 188 1/1/05
4455 145 1/1/05

When you sum the column A it gives you a value of one for each occurance,
but I'd like to tell me the number of patients (1) at visited not number of
proceedures (3).