Harshana WeragamaCalculating “Equated Monthly Installment (EMI)”A very happy new year to all my readers, and hope 2023 will bring everything good. Have been busy with some personal matters and could not…Jan 16, 2023Jan 16, 2023
Harshana WeragamaCalculating totals with logical testWhat if you are faced with a situation where you need to calculate summations based on meeting a single criterion? And there is a quite a…Aug 26, 2022Aug 26, 2022
Harshana WeragamaRanking based on multiple factorsWhilst the most common mode of build a rank would be with the use of RANK function, unfortunately excel does not have a function created…Aug 25, 2022Aug 25, 2022
Harshana WeragamaRankingIn some instances you are faced with a situation of ranking a series of values, based on the largest value to the smallest value or vice a…Aug 16, 2022Aug 16, 2022
Harshana WeragamaLooking up values or dataIn my line of work there are more than one point of data, and sometime, you do need to create points to lookup a set of data and return a…Mar 4, 2022Mar 4, 2022
Harshana WeragamaValidation listSometimes you have one set of information that you need to keep on repeating, on each row. These would sometimes be things likeFeb 3, 2022Feb 3, 2022
Harshana WeragamaWind Rose ChartIn the resent past I have been seeing many charts that looks cool to the eye, and was wondering whether I could create this on Excel. One…Jan 11, 2022Jan 11, 2022
Harshana WeragamaYears, Days and MonthHow many of you have struggled to find the number of years, months and days between two dates. I am sure many have which includes me…Dec 10, 2021Dec 10, 2021
Harshana WeragamaColouring a column based on dayI often have worksheets where a there are columns representing the dates of the month. In the with certain data is marked from date to date…Nov 17, 2021Nov 17, 2021
Harshana WeragamaAged analysisSometime back a young one who is know to me in a finance division asked me how do I do an aged analysis of receivables.Nov 9, 2021Nov 9, 2021
