Example: for two cells A2 and C2 I am looking for a formula in A2 that will copy the final entry in C2 when the information from other parts of the spreadsheet are moved more than once into C2.
Such as cell entries elsewhere "abc", "def", "xyz" that can be moved in and out of cell C2 until satisfied with the final entry. It is the final entry in C2 that I want to see in A2.
Such as cell entries elsewhere "abc", "def", "xyz" that can be moved in and out of cell C2 until satisfied with the final entry. It is the final entry in C2 that I want to see in A2.