Hi there,
I've currently got the numbers 1-1000 going down the A column. However, I need to add the identifier in J4 to each of them. I assume there's a quicker way than manually typing "=1+J4" and "=998+J4"?
Thanks
Hi there,
I've currently got the numbers 1-1000 going down the A column. However, I need to add the identifier in J4 to each of them. I assume there's a quicker way than manually typing "=1+J4" and "=998+J4"?
Thanks
Clean all expected results in column A.
A1
=SEQUENCE(1000)&J4
Thank you very much. How would I keep the formula going? I'd need 1001-2000 to count 1-1000 again but read J5 instead of J4. Ideally need it all to be in the same column as I'll be using it with a VLOOKUP.
Try this,
Please Login or Register to view this content.
Perfect! Thanks so much.
You are welcome.
-----------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks