loop a list with the IF formula

U

ufo_pilot

My list allows 30 names from A7:A36 (this list should be copied to row B,
with a looping effect)
But if not all 30 cells are filled in (may only have 10 voulunteers to do a
job), how do I ust the formula IF the cell in the next row is empty, then
go to the top cell and start over ( this is what I have so far, but it does
not work as a loop and repeat the first entries over and over, regardless of
if there is two or more entries) =IF(A8="",A7,IF(A8=A7,A7,A8))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column formulas to subtract value from value 4
Find the first & subsequent cells to contain text in a column & re 28
Array Match Formula 1
Another Hyperlink Question 4
Copy value from cell above 6
a twist to relative ranges 5
Formulas only calculate a result when there is matching data in ce 2
Help on filling empty cells with string + row() 1

Top