COUNT UNIQUE DUPLICATE VALUES IN EXCEL

COUNT UNIQUE DUPLICATE VALUES IN EXCEL

COUNTIF is an excellent function to count only those cells whose value meets certain criteria. But as excellent as it is, it becomes a challenge to count Unique or Repeats in a range that contain duplicates. For example, Using the below data count; Total number of...
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...
Excel RAND() and RANDBETWEEN Functions

Excel RAND() and RANDBETWEEN Functions

The human being cannot consciously generate random numbers sequences as they tend to avoid/favor picking specific numbers yet there is so much application of randomness in life. Random numbers are useful in a number of ways, such as generating data encryption...
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...