Most Reoccurring Text Between 2 Dates Excel

user_18704351 0
Viewed 30

Got a bit of a pickle. Trying to find the most used delivery company for orders in a specific month. Say the company was in Column A, and order date was in Column B, how would I go about finding the most repeated value?

I've been searching to find a solution but can't find anything, had even considered manually going through but there's over 2000 entries each month aha

formula excel
1 Answers

You can use:

=LET(rng,FILTER(A:A,(B:B>=DATE(2022,01,01))*(B:B<DATE(2022,02,01))),
    INDEX(rng,MODE.SNGL(MATCH(rng,rng,0))))

This will return the most frequent for the month of January for 2022.

enter image description here

E:F is just there to prove that it is returning the most reoccurring text.

user_48515900
Related