Forum Discussion
Returning multiple column headers based on duplicated dates within a row
Hi I have read many similar questions & answers, but none of the replies seem to work with my data. I have a spreadsheet with dates in varying order from left to right and some blank cells within ea...
=IFERROR(BYROW(AX2:BF19,LAMBDA(row,TEXTJOIN(",",,FILTER($AX$1:$BE$1,TAKE(row,,8)=TAKE(row,,-1))))),"")Does this return the intended result for the sample data? The ranges of the formula can be adapted to the actual size of the data.
Again many thanks for your help. Looking at this above it looks perfect. Sadly it is not working when I put it into my worksheet. I'll upload a sample.