Board index MS EXCEL

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
 
 
 
Top

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,

 
 
 
Top

1. How to find serial nos (unique H/W nos) of peripherials , any devices in a PC

2. How do I print several pages with unique serial No's in Word 2002

3. unique sequential serial number for group of records

4. Help please- unique sequential serial number for group of records

5. QUESTION: Getting unique identifier of PC (processor serial number, hd serial number, nic id, etc...)

6. how to find nos. of each day in certain nos. of days?

7. i want to give serial no's for reporting

8. Doc. Page Nos. vs Sec. Page Nos.

9. Studio8 Serial No's Problem..

10. OEM Serial No's & Changing them

11. How can I stop Merged nos. from excel having 6-7 nos after dec

12. Serial Nos on Report

13. Alignment of bracketed negative nos. with positive nos. in table

14. How can I stop Merged nos. from excel having 6-7 nos after decimal

15. Unique Values v Unique Records

All times are UTC
Board index