LinkBack URL
About LinkBacks
Hello. I am looking for a formula that will repeat each cell value 3 (Multiple) times.
For example:
Column A
Row 1: A
Row 2: B
Row 3: C
Desired Outcome:
Colum B
Row 1: A
Row 2: A
Row 3: A
Row 4: B
Row 5: B
Row 6: B
Row 7: C
Row 8: C
Row 9: C
Thanks.
Hello. I am looking for a formula that will repeat each cell value 3 (Multiple) times.
For example:
Column A
Row 1: A
Row 2: B
Row 3: C
Desired Outcome:
Colum B
Row 1: A
Row 2: A
Row 3: A
Row 4: B
Row 5: B
Row 6: B
Row 7: C
Row 8: C
Row 9: C
Thanks.
try this in B1... =(INDEX($A$1:A1,ROUNDUP(ROW(B1)/3,0))) and drag down.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
It worked. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks