REVERSE LOOKUP USING VBA

REVERSE LOOKUP USING VBA

This is the last article in the series of reverse lookup in excel. Unless you are already versed with Reverse Lookup, consider checking below 2 articles first; Reverse Lookup & Reverse Lookup with duplicates Now using VBA we are going to look up the date, time and...
REVERSE LOOKUP IN EXCEL

REVERSE LOOKUP IN EXCEL

In my research and tutoring excel, I have found that many people find the Reverse lookup concept to be among the top 10 complicated things in excel. This article hopes to shed more light than heat in demystifying the Reverse Lookup in excel. In the normal lookup, we...
2 WAY LOOKUP IN EXCEL

2 WAY LOOKUP IN EXCEL

The ability to lookup values is a MUST have skills for all Excel users. If you cannot lookup you cannot excel in data analysis. In this article, I will show you  5  ways you can do a 2-way lookup in Excel. 1. USING SUMPRODUCT Using below sales data lookup and sum the...
LOOKUP and SUM IN EXCEL

LOOKUP and SUM IN EXCEL

Array formulas come in handy when you want to look up and sum a large amount of data. Array formulas can replace multiple normal formulas, perform multiple calculations and return a single value as a result. For example, using below Main sales data in Quantity and a...
WILDCARDS IN EXCEL

WILDCARDS IN EXCEL

A Wildcard is a symbol used to replace or represent one or more characters. Excel wildcards are either an asterisk (*) which represents one or more characters, a question mark (?) which represents a single character or a tide (~) used to distinguish between normal...
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...
Excel RAND() and RANDBETWEEN Functions

RANDOMLY ASSIGN GROUPS

If your involves sampling, research, taking polls or working with control groups, then knowing how to  randomly assign groups is a key skill. Random assigning of groups ensures each participant or subject has an equal chance of being placed in any group and...