Repeating patterns of mutiple formulas by rows
Posted by Marty on April 13, 2001 9:03 AM
I have a situation where I am trying to have line 1 in a result tab look at line 1 in a data tab. Then line 2 in the result tab look again at line 1 in the data tab. Then, have line 3 in the results tab look at line 1 again in the data tab.
After that, line 4 in the results tab would start to repeat the above pattern. I try to copy automatically by clicking and dragging downwards but have yet to find the proper way to make the pattern repeat correctly.