Formula help

[snash]

Hi there,
I've got a column with lots of customer codes like W456 or w456. I want to be able in another column to take all the codes and add the number 1 to those that are duplicates butjust have a small letter instead of the big letter in front.
Is this possible?

 

[Habtest]

Like this?

Book1
	A	B
1	W456	W456
2	W456	w457
3	W456	w458
4	X100	X100
5	X100	x101
Sheet3

Cell Formulas
Range	Formula
B1:B5	B1	=IF(COUNTIF($A$1:A1,A1)-1,LOWER(LEFT(A1,1))&RIGHT(A1,3)+COUNTIF($A$1:A1,A1)-1,A1)

 

[snash]

Hi there, thanks for coming back to me.
In A1 I have W456. In A2, I have w456. In A3 I have C000 and in A4 I have c000 and so on.
In Column B, how can I add the number 1 to the end of the the small lettered cells. I have about 18000 lines and not all the rows are duplicates (except for the small and capital letter) but there are a lot that are.
Thanks again

 

[kweaver]

How about this in B1 and filled down? I assume you don't mean "ADD" (i.e.., w456 doesn't become w457) but mean "CONCATENATE" a 1??

FuzzyLookup1.xlsm
	A	B
1	W456	W456
2	w456	w4561
3	C000	C000
4	c000	c0001
Sheet2

Cell Formulas
Range	Formula
B1:B4	B1	=IF(EXACT(LEFT(A1,1),LOWER(LEFT(A1,1))),A1&"1",A1)

 

[snash]

Oh yes- that's perfect - thank you so much.