1 vote

Autocomplete Excel formula with keyboard shortcut

Solved, my misake. (I mapped TAB to an Autohotkey shortcut for some tests the last days.)
Basj's user avatar
  • 1,748
1 vote

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: =...
slimcity5's user avatar
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 ...
merof's user avatar
  • 11

Only top scored, non community-wiki answers of a minimum length are eligible