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 column 8 without me having to copy and paste the dates to column 8 one by one, row by row.
Is it possible to input my dates in a column and row and they automatically appear in an additonal column without me having to copy and paste each data independently? If yes, Please provide me with a how to.
I created the 8th column so I can set our church membership chronologically with oldest date to most recent dates. I am inputting our membership to data storage. Our church is over 100 years old and the data at this time cannot be easily found when requests are made by family members for baptism records.
Thank you, CindyLackey
3 Replies
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)CindyLackey Since you mention that you are using MS365, the TEXTJOIN function will smoothly combine the three dates into a string of three "numbers" that you could then sort. And if you do that in a structured table, the formula will copy itself down when you add more data later on.
But I wonder why you would want to do that at all. If you have three date columns that you want to sort on, you can use a custom sort. First by Baptism, then by Letters, then by Statements. No formulae needed.
- Check out the Concatenate function
