by Crispo Mwangi | May 13, 2022 | INTERMEDIATE EXCEL
Accurate data entry saves tonnes of time in data clean up & analysis. Below is how to Allow Only UPPERCASE, lowercase, Or Proper case Entries in Excel. How it Works The EXACT Function compares two text strings and returns TRUE if they are the same else FALSE. This...
by Crispo Mwangi | Apr 11, 2022 | INTERMEDIATE EXCEL
By default, the SUMIFS function is not case-sensitive. To make it case-sensitive and do an exact match, follow the below steps: SUMIFS COMPLETE EXACT MATCH Alternative 1: Using a combination of SUM, IF & EXACT We shall start by doing a complete exact match then a...
by Crispo Mwangi | Oct 29, 2021 | INTERMEDIATE EXCEL
Knowing how to Analyse Multiple Choice Survey Data In Excel is a must-have skill since Multiple choice questions are the most popular questions. For example, a Bank has requested it, customers, to rate 3 of its department’s services from Very Unsatisfied (-100%)...
by Crispo Mwangi | May 27, 2021 | INTERMEDIATE EXCEL
Assume you have below data and you need to get the last name as Surname & the rest as Other Names. If only One name exists extract it as the Surname. Here are the Steps to follow: Find the position of the last word in the name.To do this you need to count the...
by Crispo Mwangi | May 25, 2020 | INTERMEDIATE EXCEL
This post is inspired by Dave Bruns’s post on Two-way approximate match multiple criteria. Having read Dave’s article I thought… “Is there an easy way of doing this using XLOOKUP instead of INDEX/MATCH?” 🤔 Option 1: Using IF Function...
by Crispo Mwangi | Apr 12, 2019 | INTERMEDIATE EXCEL
“Excel Flash Fill Is A Brilliant Time Saver,” writes Life hacker Australia. “In fact, it’s so good it feels like magic,” says Tech Radar “Flash Fill brings the power of text manipulation to the hands of common, non-technical, everyday...
Recent Comments