Data Explorer: Introduction to Data Explorer Language

In my previous blogpost I wrote about how to load data from a less-structured data source into Excel, in order to further integrate and analyze the data with tools like PowerPivot and Excel’s Quick Analysis. The example was about displaying all gas Continue reading

VLOOKUP (VERT.ZOEKEN) in Excel sometimes returns wrong value (off by one row)

Ever had that the Excel formula VLOOKUP start coming up with the wrong answer? Trouble is that most times it has the correct answer, but sometimes it doesn’t. I found the answer on the internet, see below: —————————————————————————————————- Sounds like Continue reading