I'm using Excel 2010 to count unique numbers in a column, but I can't get it to output properly. Does anyone have idea what I'm doing wrong? unique-sample.xlsx
All I want to see is the number of different ID numbers in my column of numbers. I'd prefer to set the formula for the entire column if need be, Starting at Row 5 where the data will be in the finished spreadsheet. All data above Row 5 will contain merged cells that should not be included in the results.