Sorry not at work so can't upload the file however I need a formula to count the unique values in a filtered column. The column has account names and a few are listed more than once. The filtered data is in column A (A2:A747).

Thanks!