Forum Discussion
CindyLackey
Jan 13, 2022Copper Contributor
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...
PeterBartholomew1
Jan 14, 2022Silver Contributor
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)