by Crispo Mwangi | Jan 8, 2023 | INTERMEDIATE EXCEL
Reverse lookup of numbers is easier than that of texts. Reverse Lookup Numbers For example, how do you look up the appointment date and time for a patient in the below data? The...
by Crispo Mwangi | Nov 16, 2022 | INTERMEDIATE EXCEL
VLOOKUP function is mostly underrated and assumed that it cannot return multiple items. The only trick is to use row numbers as lookup values…VLOOKUP can loop through...
by Crispo Mwangi | Nov 9, 2022 | BASIC EXCEL
Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE...
by Crispo Mwangi | Oct 19, 2022 | INTERMEDIATE EXCEL
Among many misconceptions about the VLOOKUP function is that it cannot return items repeated n times. This is not true! For example, Using the data below, can you return the...
by Crispo Mwangi | Aug 16, 2022 | HR, INTERMEDIATE EXCEL
Benjamin Franklin once said, “in this world, nothing can be said to be certain, except death and taxes”. There is nothing else as certain as these two, (except...
Recent Comments