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

Use Cell Address Lookup in formula
 

I've used a vlookup on the ApplNr to search for the previous entry of the
ApplNr for the same day and created an address lookup to change the first
cell in the vlookup range to the new date cell address. I tried the
following, but can't get it to work.

AddressLookup=ADDRESS(MATCH(B16,Dates,0),COLUMN(B1 6),4) which gives me the
cell address of the first cell for a new date and then

added to
vlookup=VLOOKUP(B16,ADDRESS(MATCH(B16,Dates,0),COL UMN(B16),4)&":"&C16),2,FALSE)
--
Hennie


"Hennie" wrote:

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