LinkBack URL
About LinkBacks
modifying the formula above to look at sheet one for the list without duplicates worked. Thanks so much for your help. Awesome.
=IFERROR(INDEX(Sheet1!$O$4:$O$80,CEILING(ROWS(C$2:C2)/5,1)),"")
modifying the formula above to look at sheet one for the list without duplicates worked. Thanks so much for your help. Awesome.
=IFERROR(INDEX(Sheet1!$O$4:$O$80,CEILING(ROWS(C$2:C2)/5,1)),"")
You're welcome. Thanks for the feedback!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks