First Occurences

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ExcelMonkey - 05 Oct 2004 13:37 GMT

I know that hthe Count Function will count the number of times that a
item occures in a list. I want to know how do I tell if its the firs
ocurrence? That is, I only want to know True/False if its the firs
occurence.

Thank

Reply to this Message

Frank Kabel - 05 Oct 2004 13:46 GMT

Hi
lets assume your data is in column A then use the following formula in
B1
=IF(COUNTIF($A$1:$A1,A1)=1,"First occurence","")
and copy this down for all rows

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I know that hthe Count Function will count the number of times that

> item occures in a list. I want to know how do I tell if its the

first

> ocurrence? That is, I only want to know True/False if its the first
> occurence.
[quoted text clipped - 6 lines]
> ExcelMonkey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5221
> View this thread: http://www.excelforum.com/showthread.php?threadid=266407

Reply to this Message