How to Return the Top 10 Names by Date and Boolean Criteria in Excel

Dedicate a cell for your date criteria (e.g., G1) and another for your Boolean True/False criteria (e.g., H1). Ensure your source data is organized in columns, for example, Names in Column A, Boolean in Column B, and Dates in Column C.

Use the FILTER function nested inside LET to extract only the names where the date matches G1 and the boolean matches H1. The logic looks like this: FILTER(A2:C16, (C2:C16=G1)*(B2:B16=H1)).

Apply the UNIQUE function to the filtered list of names. Next, use COUNTIFS to count how many times each unique name appears in the original dataset under the specified criteria.

Combine the unique names and their counts using HSTACK. Wrap this in the SORT function to order the results by the count column in descending order. Finally, wrap the entire formula in the TAKE function with a parameter of 10 to return only the top 10 rows: TAKE(SORT(..., 2, -1), 10).

Keep your reference date in cell G1. Instead of checking for an exact match, use functions like EDATE(G1, -2) to find the date exactly two months prior to the target month.

Change the multiplication array logic in your FILTER function to check a range. Replace (C2:C16=G1) with ((C2:C16<=G1)*(C2:C16>=EDATE(G1,-2))).

Keep the rest of the formula intact. The SORT and TAKE(..., 10) functions will seamlessly process the newly expanded three-month dataset and still return the highest counts.