asked on Combine THREE columns of dates from different sheet? Example file attached that does two.
the "report" flag is because I reported a feedback problem.
example file: EEDATESCOMBINE3.xls
example file: EEDATESCOMBINE3.xls
| This formula joins two date columns from different sheets, how to join a third? Preferably without embedding this formula inside itself. |
| LET( |
| RowCount1,ROWS(DatesOne), |
| RowCount2,ROWS(DatesTwo), |
| Rowindex,SEQUENCE(RowCount1+RowCount2), |
| IF(Rowindex<=RowCount1, |
| INDEX(InputData[DateDuePaid],Rowindex), |
| INDEX(DDSO[DATE],Rowindex-RowCount1))) |
Microsoft ExcelMicrosoft Office
Last Comment
Anthony Mellor
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Anthony