Mode Function - Most common value in a range - with conditions

[nickmessick1]

I have a column of Units and a column of Times. I want the condition of the Unit to be included in a MODE function to identify the most common value in a range.

Thanks for the help.

mode question.xlsx

[daddylonglegs]

You can use an "array formula" like this in G3

=MODE(IF(B$2:B$12=F3,C$2:C$12))

confirm with CTRL+SHIFT+ENTER, format as time and copy to G4