help with the function

[Igneshwara reddy]

Hi,

I need a help with the formula. I have data like this.

Column A Column B Column C Comun D
G5370-0101-6090
123456 12
253689 25

In column C the results should be as Column A 123456 should repeat 12 times
as in column B and in column D the description G5370-0101-6090 should repeat
12 times in Column D.

Please help me out with the formula.

Regards,
Igneshwara reddy.

 

[Peo Sjoblom]

Not sure what you mean?

Maybe this

=COUNTIF(A:A,B1)

copy down


--


Regards,


Peo Sjoblom

 

[Marcelo]

column C
=rept(a2,b2)

a2 = 123456
b2 = 12


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Igneshwara reddy" escreveu:

 

[Igneshwara reddy]

Hi,

The formula worked with REPT, but the result is displayed in single cell.
The result what I expect is to display in different rows from the number of
times it should repeat.

Regards,
Igneshwara Reddy.