Most frequent price used ?

[makinmomb]

I am looking for some rare dead stock items that have no selling
price in the system ,

I am trying to find the most frequent price used

Formula on b1 , expected result needs to be 1939.66

I know the below formula but will be slow as than I have
still strain my eyes

Please Login or Register  to view this content.

[mrice]

Try

=MODE(A1:A14)

gives a different answer to the one you suggested.

[makinmomb]

Mode is correct and 1724.13 is correct too as appears 3 times while 1939.66
appears twice ,

Mrice you made my day I hope i will sleep earlier , since I have to finish before
waking up for morning