Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
cell address from formula | Excel Discussion (Misc queries) | |||
V Lookup and return cell address | Excel Worksheet Functions | |||
How do I use cell contents as an address in a formula | Excel Worksheet Functions | |||
Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell | Excel Worksheet Functions |