I have a sheet which has a list of numbers in column A. Each number appears only once but I need each number to appear 6 times.
So, this....
432740093
412620001
412620002
Would become...
432740093
432740093
432740093
432740093
432740093
432740093
412620001
412620001
412620001
412620001
412620001
412620001
412620002
412620002
412620002
412620002
412620002
412620002
Is there a simple formula for this procedure?
Any help would be greatly appreciated
Regards
It can be done quite simply with a helper column (see attached). But if your list is long VBA would be better.
Let us know if you need further help.
Dave H
- Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
- Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
Using Dave's example sheet, without violotile fumction and without helper column, in B2 use this formula and copy down.
=INDEX($A$2:$A$12,1+(ROW(A1)-1)/6)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Perfect! Thanks for such quick help with this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks