column designators

T

tims

I need to auto derive data for column A using "-" as an identifier fo
input from Column B. See below:

Column A Column B
S14134 S14134
S14134 S14134-1
S14134 S14134-2
S14134 S14134-3

Any help is appreciated.

Tim
 
R

Ron Coderre

Hi, Tims

With your references in Col_A, beginning in A1

B1: =A1&TEXT(COUNTIF($A$1:A1,A1)-1,"-0;-0;")
copy that formula down as far as you need

Does that help?

Regards,
Ro
 
R

Ron Coderre

I may have mis-read your post....

If you want to use the reference in Col_B to calculate the bas
reference in Col_A, then...

For a reference in B1,
A1: =LEFT(B1,FIND("-",B1&"-")-1)

Does that help?

Regards,

Ro
 
Top