help with the function
 

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.

help with the function
 

Not sure what you mean?

Maybe this

=COUNTIF(A:A,B1)

copy down


--


Regards,


Peo Sjoblom



"Igneshwara reddy" wrote in
message ...
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.

help with the function
 

column C
=rept(a2,b2)

a2 = 123456
b2 = 12


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



"Igneshwara reddy" escreveu:

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.

help with the function
 

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.

"Marcelo" wrote:

column C
=rept(a2,b2)

a2 = 123456
b2 = 12


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



"Igneshwara reddy" escreveu:

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.