I am struggling with Mode and Aggregate formulas to no avail.
I am working on a report that I need to find the most common reoccurring value based on two criteria.
The reoccurring column is failure codes, which as my title suggests may contain several duplicates.
The criteria I need to reference is the widget part number and the manufacturing year, each are in two different columns.
Any help on how to handle this as one formula?
Bookmarks