At 4:52 p.m., AutoFill changed 1,200 ‘County’ entries to ‘Country’ and I only noticed when Nebraska became sovereign. If my hotfix is a blind find/replace, what happens if this scales?
Filter County column for ‘Country’, replace, then add Data Validation — preventing another ‘Nebraska became sovereign’; using AutoFill?
, AutoFill turning County into Country at 4:52 p.m. is brutal — “Nebraska became sovereign” broke me. Quick non-blind fix: Ctrl+H on just the County column with Match entire cell contents so only literal “Country” cells revert, then right-click drag the fill handle and choose Copy Cells so Excel stops guessing. If you’ve got legit Country elsewhere, limit the replace to the selected range — does that cover your 1,200 rows?
If this hit at “4:52 p.m.,” open File > Info > Version History, open the 4:51 version, and copy that column back into your current file — time‑travel beats whack‑a‑mole. If you’re on OneDrive/SharePoint it’s quick; steps here: https://support.microsoft.com/office/view-previous-versions-of-office-files-5c1e076f-a9c9-41b8-8baa-30b8bb269a7a. Are you saving to OneDrive or SharePoint?