to give numbers to rows as per your wish

[sumesh56]

i have some 2000 plus records in a worksheet. i want to give th
adjoining records numbers as 1A, 1B(for rows 1,2) 2A,3B(for rows 3,4)
3A, 3B (for rows 5,6) ----in this order. is it possible?
the first of each is a song title and second is th
lyricist/musicdirector/singer
it should look like this

1A i want to sing
1B titanic/frac/jessy
2A heartful
2B george/perse/ki9

 

[Claus Busch]

Hi Sumesh,

Am Wed, 4 Apr 2012 02:46:48 +0000 schrieb sumesh56:

1A i want to sing
1B titanic/frac/jessy
2A heartful
2B george/perse/ki9n

in Row1:
=IF(ISODD(ROW()),ROUND(ROW()/2,0)&"A",ROW()/2&"B")
and copy down


Regards
Claus Busch

 

[Claus Busch]

Hi Sumesh,

Am Wed, 4 Apr 2012 09:49:22 +0200 schrieb Claus Busch:

in Row1:
=IF(ISODD(ROW()),ROUND(ROW()/2,0)&"A",ROW()/2&"B")
and copy down

or in row1:
=IF(ISODD(ROW()),ROW()/2+0.5&"A",ROW()/2&"B")


Regards
Claus Busch