Thread: Adding Number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Adding Number
put in C6 then copy down

=IF(B6="E";COUNTIF($B$6:B6;"E")&"E";"")

Reply With QuoteReply With Quote