Try then in first cell:
=IF(L3>0,INDEX(INDEX(J:J,IF(ROW()>100000,ROW()-100000,ROW())):J2,L3,1),"")
copied down.
Try then in first cell:
=IF(L3>0,INDEX(INDEX(J:J,IF(ROW()>100000,ROW()-100000,ROW())):J2,L3,1),"")
copied down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks