I have a spreadsheet and need help on a formula. In column A, there are lots of random numbers, many of which repeat. In column B, I am trying to figure out a formula that will count how many different numbers are there. COUNTIF won't work. Please see the attached spreadsheet as an example. Its hard to explain, the spreadsheet will make more sense.