I have tried to come up with a way so that the letters repeat precisely four times. Specifically, so that in each situation where Column C equals more than 0, Column A repeats itself four times in another column. What sort of formulas should I use?
I have tried to come up with a way so that the letters repeat precisely four times. Specifically, so that in each situation where Column C equals more than 0, Column A repeats itself four times in another column. What sort of formulas should I use?
Last edited by Enda80; 02-02-2014 at 09:46 PM.
http://stackoverflow.com/questions/9...active#tab-top
I found this formula. Adjusting for rows might work.
=INDEX($A$5:$A$100,INT((ROWS(A$1:A1)-1)/3)+1)
http://www.excelforum.com/excel-gene...wn-column.html
Your sample is not that clear, but if I undwerstand you correctly, try this. 1st, create a small table to hold your letters and corresponding numbers (G1:H4, you can expand this if needed)...
Then use this, copied down...
G H 1 0H 2 1B 3 2C 4 3I
=VLOOKUP(MOD(ROW(),COUNT($G:$G)),$G$1:$H$4,2,0)
It will adjust automatically to the amount of numbers you want inthe table
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
One venture ... based on what's in A1:A95
you can use this in any startcell, eg in L1: =INDEX($A$1:$A$95,INT((ROWS($1:1)-1)/4)+1)
Copy down as far as required to repeat each source cell 4 times
Thanks for the people who replied and for those who contributed to the cited thread. I feel I
have the issue resolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks