sequential numbering

[melons]

I need to make make columns auto number in a certain order. Maybe someone can help

[TABLE="width: 279"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 279"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]F19130[/TD]
[TD]F19130[/TD]
[/TR]
[TR]
[TD]F19130[/TD]
[TD]F19130f[/TD]
[/TR]
[TR]
[TD]F19131[/TD]
[TD]F19131[/TD]
[/TR]
[TR]
[TD]F19131[/TD]
[TD]F19131f[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]


Can it be done?


Thanks for any help[/TD]
[/TR]
</tbody>[/TABLE]

 

[sadboy309]

I don't understand. What is word "f" and number auto where? IF you plus word "f" into, you can [Countif(..) >1].

Select case [Countif(..) >1]:
=IF(Countif($A$1:A1,A1)>1, A1 & "f", A1)

 

[melons]

I don't understand. What is word "f" and number auto where? IF you plus word "f" into, you can [Countif(..) >1].

Select case [Countif(..) >1]:
=IF(Countif($A$1:A1,A1)>1, A1 & "f", A1)

f is for to payables in zed axis. it only keys off different numbers when entering payables.. I am not that good at this and hate manually typing in rows of numbers.. How do i enter the formula?

Thanks for the help