Forum Discussion
Excel - Count how many months a specific metrics may be highest
I am attempting to create a comment generator for a variety of KPI's and am looking for excel to use a month selected via dropdown and subsequently read off of a Pivot Table (can use standard table r...
I think you can do this using XMATCH instead. So if you have a row of data and use a formula like:
=XMATCH( [lookup Val], [row of Data], 1,1) -1
that should tell you how many previous months are smaller than this value
=XMATCH( [lookup Val], [row of Data], 1,1) -1
that should tell you how many previous months are smaller than this value