Is this easy to do?

[stone]

hi guys.

I dont know if this is easy to do,.
My problem is as follows...

In each cell in column A I have a number from 0 to 99. If cellA1 is 0 then cell B1 is supposed to have 0+01 that is 001.

I will give an example.

column A...Column B
...0.......001
...0.......002
...1.......101
...1.......102
...0.......003
...4.......401
...1.......103
..54......5401
..54......5402
..1........104

Does anyone understand what Im trying to do?
Is this possible?
If you have any idea please share it with me.

Thanx
Stulli.

[Ian Mac]

On 2002-05-14 03:55, stone wrote:
hi guys.

I dont know if this is easy to do,.
My problem is as follows...

In each cell in column A I have a number from 0 to 99. If cellA1 is 0 then cell B1 is supposed to have 0+01 that is 001.

I will give an example.

column A...Column B
...0.......001
...0.......002
...1.......101
...1.......102
...0.......003
...4.......401
...1.......103
..54......5401
..54......5402
..1........104

Does anyone understand what Im trying to do?
Is this possible?
If you have any idea please share it with me.

Thanx
Stulli.

if the count is NOT like to be greater than 10 then use:

=(A1&"0"&COUNTIF($A$1:A1,A1))+0

if the count is likely to be greater than 10 at any point use:

=(A1&IF(COUNTIF($A$1:A1,A1)>=10,COUNTIF($A$1:A1,A1),"0"&COUNTIF($A$1:A1,A1)))+1

hope this helps

_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-05-14 04:23 ]

[pmdown]

in cell B1 type:

=CONCATENATE(TEXT(A1;"@");"0";TEXT(COUNTIF($A$1:A1;A1);"@"))

and drag down...

[michelle]

Try as follow
on column A = { 0, 0, 1, 1, 0, 4, 1, 54, 54, 1 }

column B
cell B1 = IF(A1="","",COUNTIF($A$1:A1,A1))
cell B2 = IF(A2="","",COUNTIF($A$1:A2,A2))
cell B3 = IF(A3="","",COUNTIF($A$1:A3,A3))
...etc

column C
cell C1 = concatenate (A1, TEXT(B1,"#00"))
cell C2 = concatenate (A2, TEXT(B2,"#00"))
cell C3 = concatenate (A3, TEXT(B3,"#00"))
... etc

and you have to fill only column a


I hope it'll help you

[Aladin Akyurek]

On 2002-05-14 04:23, Ian Mac wrote:

if the count is NOT like to be greater than 10 then use:

=(A1&"0"&COUNTIF($A$1:A1,A1))+0

I believe Stulli wants to have/keep leading zeroes, so

=A1&"0"&COUNTIF($A$1:A1,A1)

will suffice.

Aladin

[stone]

Thanx alot guys, you have fixed my problems.

Your help saved my day (for now)

BK
Stulli