Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
generating unique reference number
I have the following set of data
Trust Account Number SI date (SDA booking date) Principal Amount TF Rate RESULTING VALUES 01 0500247 22-Sep-08 12,000,000.00 0.25% 01 0500247_0001 01 0500324 20-Oct-08 5,000,000.00 0.25% 01 0500324_0001 01 0500340 05-Sep-08 1,000,000.00 0.55% 01 0500340_0001 01 0500340 10-Sep-08 1,000,000.00 0.55% 01 0500340_0002 01 0500340 19-Sep-08 4,000,000.00 0.35% 01 0500340_0003 01 0500340 22-Sep-08 5,000,000.00 0.35% 01 0500340_0004 01 0500340 22-Sep-08 5,000,000.00 0.35% 01 0500340_0005 Can anyone help me in coming up with a code that will generate the resulting values? Note that columns a-e are inputted manually while column F should be automatically generated. THANKS! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I generate a unique reference number??? | Excel Discussion (Misc queries) | |||
Generating Unique Numbers | Excel Discussion (Misc queries) | |||
Generating Unique Sequential Numbers | Excel Discussion (Misc queries) | |||
generating Unique ID numbers for students | Excel Worksheet Functions | |||
generating Unique ID numbers for students | Excel Worksheet Functions |