Master Excel values vlookup – How to do vlookup

When applying vlookup on lists from different sources, you might easily end up not being able to match values. Typical example : SAP extract compared to your local text file, Excel list compared to an SAP extract, Excel list compared to a text list, … See example above. First list as an Excel, second list […]

Excel 2013 order a list and remove duplicates

Ordering a list and removing duplicates is a common and useful operation, when working with data lists : email addresses, invoice numbers, values, … One solution to quickly process large sets of data can be to use Notepad++. Another possibility is using Excel 2013 from Microsoft Office 2013 suite.       Starting with your […]

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this. More information on