1
vote
Autocomplete Excel formula with keyboard shortcut
Solved, my misake.
(I mapped TAB to an Autohotkey shortcut for some tests the last days.)
- 1,748
1
vote
Accepted
Excel Formula To Get Last Non Zero or Not Blank Value in Column And Return Value
If there's anybody else who finds division by zero/FALSE to be aesthetically displeasing then here are some alternatives:
• An efficient XLOOKUP method if you're dealing with strings, not numbers:
=...
- 26
1
vote
Search text in multiple Excel files
I created a python script (for my own needs) that allows to search for all excel files listed in a csv (csv created either manually or by an awesome must-have Everything tool)
It can search for ...
- 11
Only top scored, non community-wiki answers of a minimum length are eligible