View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ppatel@findsvp.com is offline
external usenet poster
 
Posts: 1
Default ranking each employee

Hi, I have set for questions for each employee, i need to just number
each record

Example
------------------------

EmpNo QuestionNo RecordNo
-----------------------------------------------------------
1001 1 1
1001 2 2
1001 4 3
1002 1 1
1002 6 2
1003 1 1

For each employee I need record number, and i have over 10000 records
so something automated would be really helpful

Thanks