View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hennie[_2_] Hennie[_2_] is offline
external usenet poster
 
Posts: 11
Default Use Cell Address Lookup in formula

I need to add Date & ApplNr to a Timesheet. To view a summary on a weekly
basis, I need to number the ApplNr with a unique number every day. So each
day the numbers must start from 1 and should an ApplNr be repeated, the same
number must be allocated to that day's ApplNr. The numbers should look like
the following:

Date ApplNr Nr
14 Jan S123 1
14 Jan S123 1
14 Jan S124 2
15 Jan S124 1
15 Jan S124 1
15 Jan S123 2

Can anybody please help?
Thanks
Hennie