How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
Hosted on MSN

Stop writing nested IFs and IFS formulas in Excel: Use SWITCH instead

Messy Excel formulas are more than just an eyesore—they're harder to maintain. Every repeated cell reference and tangled parenthesis makes your work difficult to audit, edit, and share. That's why you ...
GitHub

FS2020Control: Export Control Settings in Microsoft FS2020 (FS2024?) to SQLite, Excel and Pdf

This release contains a temporary workaround for users who got the message "Multiple settings directories found; don't know which one you want" when installing FS2024. Since I have no FS2024 yet, I ...
GitHub

Read and write Godot export_presets.cfg files.

This library provides a simple way to programmatically manage Godot export presets. It handles parsing the config file format, merging presets, and includes base presets for common platforms. This ...