Unique values depending on variable

Hi guys,

I have a problem I can't solve. I have a workbook that has two sheets on it.

In Sheet 1, cell A2 I have a variable, in this case it's a number 249

In Sheet 2, I have an annual leave report which shows entries for colleagues with annual leave booked in the future. Due to the fact that a colleague could book more than 1 lot of leave, I'd like the number of unique employee numbers from the variable in Sheet 1, Cell A2.

The variable in Sheet 1, Cell A2 will be looking for corresponding data from Sheet 2, Column I. The employee numbers are located in Sheet 2, Column A.

Is this possible ?


Sheet 2 Data

ColA Col I

68917 John Daly 249
12249 Tiger Woods 249
68917 John Daly 249
12249 Tiger Woods 249
2262 Bill McGrath 249
68917 John Daly 249