środa, 20 stycznia 2016

Excel - fast vlookup with Dictionary (MSScriptingRuntime)

I found an interesting entry: http://stackoverflow.com/questions/18656808/how-to-optimize-vlookup-for-high-search-count-alternatives-to-vlookup The formula is a table one and is entered with Ctrl+Shift+Enter. I added Application.Volatile to see live updates. Small limitation: It needs to be entered every 65536 rows if the column is longer.

Brak komentarzy:

Prześlij komentarz