Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if and when HELP!!!
Guys, I have a student record excell sheet.
A1 heading= Student ID, in the format of first three letters of last name and first three letters of first name.. However, i want to add a unique number on to the end, to ensure when a sitatuin occurs when two students can have the same ID, it will not effect the linked database. So i want a formula which will give me, for example if my name is jack powers, i currently have the formula which gives me powjac, i want a formula which will search the table for a duplicate id of powjac and if, there is a duplicate put 02, 03, and so on for each person with same name\ there ISNT a duplicate to put 01. Thanks guys |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|