Dark Mode has its drawbacks. For example, the worksheet grid usually remains white. You can choose Black under Office Theme, which activates a Dark Mode toggle in the View tab of your Excel ribbon.

Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.

AGGREGATE was built to handle messy data from the start.