Automatic Row Name

[ionelz]

K13---1---3
K29---2---9
K68---6---8
X4----0---0
X5----0---0
X6----0---0

In column B and C I have numerical Data
I want an automatic name row in column A

If B1<>0 and C1<>0 THEN "K"&B1&C1

If B1=0 and C1=0 THEN "X"4
4 because I have 3 rows <>0 so I want to start with next one

[Fluff13]

Maybe

Please Login or Register  to view this content.

[GeoffW283]

Please try the following an A1 copied down:
=IF(AND(B1<>0,C1<>0),"K"&B1&C1,"X"&ROW())

[ionelz]

No, because I need to count how many C<>0 and d<>0.
It happened to be 4 here so row() work
Sorry, I am starting at row 5

[ionelz]

Thanks all, I got it, Row()-5
Thanks

[Fluff13]

Glad you sorted it & thanks for the feedback