On Thu, 25 Dec 2008 07:27:27 -0500, Ron Rosenfeld
wrote:

On Wed, 24 Dec 2008 15:16:01 -0800, Igneshwara reddy
wrote:

Hi,

I have a data in column A for 800 lines.

Column A Column B Column C Column D Column E
123 3 123-002 123-003 123-004
432 2 432-002 432-003

As defined above, the data what I have in Column A should be counted the
number of times in Column B and it has to repeated so many times in different
columns with the sequence of 002, 003 004 etc., The sequence should start
only from 002 and should continue to the number of times it has to be
repeated.

Please help me out.

Regards,
Igneshwara Reddy.


If your data starts in row 1, then:

C1: =IF(COLUMNS($A:A)$B1,"",$A1&TEXT(COLUMNS($A:A)+1, "\-000"))

Fill right as far as required. The select C1:Cn and fill Down as far as
required.
--ron

One note:

The use of COLUMNS($A:A) vs using COLUMN() as a method to generate the serial
numbers will behave differently if you should Insert a column.

e.g:

=IF(COLUMNS($A:A)$B1,"",$A1&TEXT(COLUMNS($A:A)+1, "\-000"))
or
=IF((COLUMN()-2)$B1,"",$A1&TEXT(COLUMN()-1,"\-000"))

Using the first method, the result of the calculation will be unchanged; using
the second, the result of the calculation will change depending on the column
number after the insertion.

Which is "better" depends on your specifications for what should happen in this
instance.
--ron