Snasui Excel Forum

Hi there!

I need to get repetitive value multiple times.is there any formula to cope with?

I attach a sample for your reference


TY

...

C2
=INT(ROWS($A$2:A7)/COUNT($A$2:$A$7))

D2
=INDEX($B$2:$B$7,MOD(ROWS($A$2:A7),COUNT($A$2:$A$7))+1)

Norkaz

thank you