I'm using this formula to count my records =IF(LEN(B1),COUNTA(B$1:B1),"")
Is there a way to add letters to the count. I want it to count like this in
the spreadsheet.

ALE1
ALE2
ALE3
ALE4
ALE5...

"daddylonglegs" wrote:


Try this formula in A1 copied down

=IF(B1,COUNT(B$1:B1),"")

if column B just contains numbers, if possibly text

=IF(LEN(B1),COUNTA(B$1:B1),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513069