Harshana Weragama – Medium

Harshana Weragama

Harshana Weragama

Calculating “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…

5 min readJan 16, 2023

--

Calculating “Equated Monthly Installment (EMI)”

--

Harshana Weragama

Calculating totals with logical test

What 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…

4 min readAug 26, 2022

--

Calculating totals with logical test

--

Harshana Weragama

Ranking based on multiple factors

Whilst the most common mode of build a rank would be with the use of RANK function, unfortunately excel does not have a function created…

3 min readAug 25, 2022

--

Ranking based on multiple factors

--

Harshana Weragama

Ranking

In 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…

5 min readAug 16, 2022

--

Ranking

--

Harshana Weragama

Looking up values or data

In 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…

8 min readMar 4, 2022

--

Looking up values or data

--

Harshana Weragama

Validation list

Sometimes you have one set of information that you need to keep on repeating, on each row. These would sometimes be things like

5 min readFeb 3, 2022

--

Validation list

--

Harshana Weragama

Wind Rose Chart

In 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…

6 min readJan 11, 2022

--

Wind Rose Chart

--

Harshana Weragama

Years, Days and Month

How 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…

6 min readDec 10, 2021

--

Years, Days and Month

--

Harshana Weragama

Colouring a column based on day

I 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…

7 min readNov 17, 2021

--

Colouring a column based on day

--

Harshana Weragama

Aged analysis

Sometime back a young one who is know to me in a finance division asked me how do I do an aged analysis of receivables.

6 min readNov 9, 2021

--

Aged analysis

--

Harshana Weragama

Harshana Weragama

I am free spirited person and enjoys sharing what I have learnt. I work extensively on Excel and with this I always try to find neat tricks.

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams