Forum Discussion
Excel in Office 365 Copy information
I have Column 3 (Baptism) with dates. I have Column 4 (Letters) with dates. I have Column 6 (Statements) with dates. I have Column 8 that I want to "Copy" the dates from each column (3,4,6) to colum...
Like Riny_van_Eekelen I doubt there is any benefit in generating a concatenated field. Personally, I would use formulas though. It is quite possible to use a worksheet to generate a report with data input fields for the filter criteria.
= SORT( FILTER(records, criterion), 2, -1)
where
"criterion"
= (baptism>baptismsFrom)*(baptism<=baptismsTo)