HLOOKUP, INDEX & MATCH OR VBA

HLOOKUP, INDEX & MATCH OR VBA

Having done a series on Verticle lookup, it is only fair to touch on the Horizontal lookup. HLOOKUP function is the most popular function for this kind of lookup but it has a number of limitations and thus one may need to know a few other ways you can carry out a...
GUID Generator In Excel

GUID Generator In Excel

Are you a developer working  with microsoft technologies and looking for a unique identifiers for  components/applications/files ? Or are you a database developer or administrator looking for primary keys tables? Well! in this article I will show you how to create...