Forum Discussion
INDIRECT Formula??
I had already done things the hard way for the first few numbers. So, what I am needing is for each set of dates (separated by yellow highlighted) I need each number in column A to be beside each set...
CatherineMadden Try the following formula-
=MAP(A442:INDEX(A442:A50000,COUNTA(A442:A50000)),LAMBDA(x,INDIRECT("A"&ROW(x))))