Finding Maximum / Minimum value of a particular category – Using Database Functions – Microsoft Excel Tips
Finding Maximum / Minimum value of a particular category – Using Database Functions – Microsoft Excel Tips
When you need to find a condition based total or average or count the below listed Excel functions can be used. SUMIF, SUMIFS AVERAGEIF, AVERAGEIFS COUNTIF, COUNTIFS
But if the requirement goes like maximum/minimum value based on the condition, we do not have function like MAXIF or MINIF. That’s where the utilization of the Database function comes in to play.
Let us take a particular scenario to…
View On WordPress














