How to repeat a row 4 times, while increasing sequence
Solved/Closed
Stumped..
-
Dec 10, 2014 at 03:53 AM
OldCoder Posts 1 Registration date Thursday February 5, 2015 Status Member Last seen February 6, 2015 - Feb 6, 2015 at 12:30 AM
OldCoder Posts 1 Registration date Thursday February 5, 2015 Status Member Last seen February 6, 2015 - Feb 6, 2015 at 12:30 AM
Related:
- How to repeat a row 4 times, while increasing sequence
- Gta 4 download - Download - Action and adventure
- Fnaf 4 download pc - Download - Horror
- Resident evil 4 remake free download - Download - Horror
- Age of empires 4 download - Download - Strategy
- Oracle reset sequence - Guide
Feb 6, 2015 at 12:30 AM
-- Use the row number in place of the -1.
-- Replace the 2135 with the number you want to start with.
-- Replace the /4 with the number of times you want to repeat.
-- Replace the "AAA_BBB_" with any other text you'd like to use.
=CONCATENATE("AAA_BBB_",TEXT(2135+INT((ROW()-1)/4),"0000000"))