Hi
I have a file containing of item numbers and all movements during a specific time frame. Below is an example from the file.

Item number Date Qty Unit
AB 2014-11-19 1 PC
CD 2015-02-16 7 PC
EF 2014-08-26 2 PC
EF 2014-08-26 3 PC
EF 2014-07-09 1 PC
EF 2014-07-09 1 PC
GH 2014-06-12 1 PC
IJ 2014-11-04 1 PC
IJ 2014-04-24 1 PC
IJ 2014-04-24 1 PC


I want to see the most common qty for each item number. I know that the function MODE.MULT can give me the most common qty for the whole file but how can I see it for each item number?

Thanks!