Automatic Ref Number on Excel

[Olly_01]

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am a basic Excel user for the windows 2000 version at work,<o></o>
I need to create a column in A that will take info from another field & add a number to it (for instance see below) but automatically do this action after I complete each other field, please give answers that are Idiot proof.<o></o>
<o></o>
Ref number| Item code| Condition |Clerk|
TZ0001 | - | Repairable |TZ |
JK0001 | - | New | JK |
TZ0002 | - | New | TZ |<o></o>
<o></o>
Many Thanks<o></o>
<o></o>
Olly<o></o>

 

[jasonb75]

Welcome to the board!

A fully automatic solution would require a VBA aproach to the problem, a quick formula solution would be

=D2&TEXT(COUNTIF(D$2:D2,D2),"0000")

This is on the basis that your first Clerk (TZ) is in D2, copy the formula into the first cell where the reference number is to be entered, then use the Autofill handle to copy it down as required.

Hope this helps

Jason