by Crispo Mwangi | Jan 22, 2023 | ADVANCED EXCEL
Surendra Reddy on Linked posed a challenge on how to Clean & Split Dirty Data as shown below There are many ways of doing this but I find it easy to use below Power Query M code let Source = Excel.CurrentWorkbook(){[Name=”Table1″]}[Content],...
by Crispo Mwangi | Jan 20, 2023 | INTERMEDIATE EXCEL
A friend recently asked me, “How do I condition format duplicates for Long Numbers formatted as text?” I thought…that is easy! Just go to condition formatting and select the in-built rule of highlighting duplicate rules. WRONG! Hardly did I know...
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 below video explains the steps Note: ⭐ It is possible to create an array of Date and Time...
Recent Comments