by Crispo Mwangi | Jul 30, 2016 | INTERMEDIATE 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...
by Crispo Mwangi | Jul 23, 2016 | BASIC 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...
by Crispo Mwangi | Jul 8, 2016 | BASIC EXCEL
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...
by Crispo Mwangi | Jul 6, 2016 | BASIC 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...
by Crispo Mwangi | Jul 6, 2016 | INTERMEDIATE EXCEL
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...
Recent Comments