Validate copied data in excel
Solved/Closed
chint99
Posts
2
Registration date
Wednesday June 21, 2017
Status
Member
Last seen
June 22, 2017
-
Jun 21, 2017 at 10:57 AM
chint99 Posts 2 Registration date Wednesday June 21, 2017 Status Member Last seen June 22, 2017 - Jun 22, 2017 at 08:51 PM
chint99 Posts 2 Registration date Wednesday June 21, 2017 Status Member Last seen June 22, 2017 - Jun 22, 2017 at 08:51 PM
Related:
- Validate copied data in excel
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Gif in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 22, 2017 at 11:03 AM
Jun 22, 2017 at 11:03 AM
Hi Chint99,
It might just be a confusing example, but all I get from your query is that R2 needs to match R1.
Also, Excel doesn't keep track of all the different entry's made to a cell. So the Original value might be 2, when it is replaced by 1, then the 2 is lost. If you want to keep track of your entries use another row.
Best regards,
Trowa
It might just be a confusing example, but all I get from your query is that R2 needs to match R1.
Also, Excel doesn't keep track of all the different entry's made to a cell. So the Original value might be 2, when it is replaced by 1, then the 2 is lost. If you want to keep track of your entries use another row.
Best regards,
Trowa
Updated on Jun 22, 2017 at 08:51 PM