Counting multiple postcodes, but only individual postcodes once

[richiebkerry]

Hello, I have a list of postcodes and wish to only count each individual postcode once and not take into account the amount it appears. Any help would be great.

 

[Fluff]

Have a look here
https://www.mrexcel.com/forum/excel-questions/1090284-sum-total-duplicated-items-list.html

 

[richiebkerry]

Thank you very much, will give it a go now.