Crispo MwangiYou don’t have to know everything to be an expert!Just a dozen or soMay 19, 2023May 19, 2023
Crispo MwangiHow to Lookup Items in a List using TOCOL functionAlthough the FILTER function is best suited for this kind of lookupMay 12, 2023May 12, 2023
Crispo MwangiTOCOL Reverse LookupIf you have been looking for the easiest way to reverse lookup data with duplicates…try the below combination of TOCOL and IFSMay 3, 20231May 3, 20231
Crispo MwangiHow to do a Two-way lookup approximate Match=XLOOKUP(K5&K6,material&hardness, XLOOKUP(K7,diameter,data,,-1),,-1)Feb 25, 2023Feb 25, 2023
Crispo MwangiHow To Use a Dynamic List to Lookup Data In Power QueryStep 1: Convert your Multiple criteria table to a list using Table.Tolist functionFeb 22, 2023Feb 22, 2023
Crispo MwangiHow to Validate Data Using SUM FunctionAre you paying more than you should? 🤔Feb 16, 2023Feb 16, 2023
Crispo Mwangi𝕯𝖎𝖋𝖋𝖊𝖗𝖊𝖓𝖈𝖊 𝕭𝖊𝖙𝖜𝖊𝖊𝖓 𝕯𝖎𝖘𝖙𝖎𝖓𝖈𝖙 & 𝖀𝖓𝖎𝖖𝖚𝖊Other than the chicken and the egg question…the other oldage question isAug 14, 2022Aug 14, 2022
Crispo Mwangi𝐋𝐀𝐌𝐁𝐃𝐀 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐟𝐨𝐫 𝐇𝐑 𝐒𝐭𝐚𝐟𝐟I am loving every step in my LAMBDA function learning.Aug 13, 2022Aug 13, 2022
Crispo Mwangi4 WAYS TO SUM DATA BY WEEK NUMBEREvery organization requires weekly summaries to monitor peak and off-peak periods. This is mostly so when you are in the production…Feb 11, 2018Feb 11, 2018
Crispo MwangiLOOKUP IS DEAD! OR IS IT?In the year 1882, a German philosopher, Friedrich Nietzsche made a claim that has revolutionalized Philosophical and Theological…Jan 21, 2018Jan 21, 2018