On 2002-08-22 17:06, PaddyD wrote:
On 2002-08-22 17:00, Mark W. wrote:
{=SUM(1/COUNTIF(A2:A11,A2:A11))}
where column A contains your names.
Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula. For more on array formulas see the Excel Help topic for "About array formulas and how to enter them".
This message was edited by Mark W. on 2002-08-22 17:02
Mark,
but by taking the len() check out, you'll end up counting blank cells as well?
=SUM(IF(LEN(Range),1/COUNTIF(Range,Range)))
Paddy
EDIT - what was up with your original post that made you retract it?
This message was edited by PaddyD on 2002-08-22 17:08