I am looking for a formula(s) in Col.3 (or other methods) to produce a result in Col. 3 from using the #s in Col.1 and Col. 2
The formula would result in copying the Col.2 ID#s to auto populate (the specified Col.1 number of times) inputted sequentially from top of Col.3 moving downward.
The formula would possibly be in Col. 3 and would result in taking the first ID# “#3” (in top of Col. 2) to appear 2 times moving downward from top of Col.3. Immediately after the top two #3s in Col. 3 would come three sets of the ID# “#4” and then immediately thereafter moving downward would come 4 sets of the ID# “#7” and then finally 1 set of the ID# “#11”.
It seems to me it would be easy in VBA but I am looking for an EXCEL formula or other things to use in EXCEL spreadsheet without use of VBA.
I have thought about VLOOKUP or OFFSET functions and possibly a COUNTIF but nothing seems to work for me. Anyone have any solutions please?
Col.1 Col.2 Col.3
Result of first 2 columns
2 #3 #3
3 #4 #3
4 #7 #4
1 #11 #4
#4
#7
#7
#7
#7
#11
Bookmarks