Hi all,

Does anyone have an idea how I count the number of unique reference number for each name in an xls? So for example, as attached, Bill has two unique reference numbers (need to be done on much bigger set of data or I would just count!)

Any suggestions would be much appreciated!

Dave

Does anyone have an idea how I count the number of unique reference number for each name in an xls? So for example, as attached, Bill has two unique reference numbers (need to be done on much bigger set of data or I would just count!)

Any suggestions would be much appreciated!

Dave