05-10-2020 09:33 AM
05-10-2020 11:45 AM
@Yugandhar__Y , here is a solution approach which uses just a series of excel formulas to achieve it.
See attached file.
Instead of just using it as is, i would suggest to go through the formulas and develop an understanding of how they worked. It would help you tweak them as per your need as necessary.
05-10-2020 09:53 PM
@Yugandhar__Y Or perhaps you mean this (see picture below).
Note: The FILTER function is currently available to Microsoft 365 subscribers in the Monthly channel. It will be available to Microsoft 365 subscribers in the Semi-Annual channel starting in July 2020.