Count unique values in non adjoining columns

[Indigo]

I am trying to find a way to count unique values in non adjoining columns in Excel 2010. I have 8 columns (AF, AN, AV, BD, BL, BT, CB, CJ) containing employee IDs and I want to be able to count only the unique values across all 8 columns. Any thoughts / suggestions?

 

[Rx_]

That is easy, use Frequency in an Array formula!
Did a lilttle search, this old article should get you started.
https://colinlegg.wordpress.com/201...unique-and-successive-values-using-frequency/