Serial nos for unique records

Serial nos for unique records

Post by VGVldGhsZX » Tue, 24 Apr 2007 01:46:01


In E2: enter 1
In E3: =IF(COUNTIF($A$2:A3,A3)=1,MAX($E$2,E2)+1,"")
Copy down as far as required
 
 
 

Serial nos for unique records

Post by Lynn » Tue, 24 Apr 2007 02:24:25

Thanks... that worked well. Just changed the MAX funtion to include a
range.. that may have be a typo error.

Regards,