Hi, I would like to find out what type of formula that I can use to find the least occurrence number in a column of numbers.

As I know I can use =mode() to find out the most appear number (the number that come out the most) but I don’t know the formula for the least appear number and the average appearing number.

Can someone help, thanks.