You can even use a VB code to find the first occurrence of the entries as follows:
Code:
Function FindNthOccurrence(Table As Range, Val1 As Variant,Val1Occurrence As Integer, Val2 As Variant,Val2Col As Integer, ResultCol As Integer)
Dim i As Integer
Dim iCount As Integer
Dim rCol As Range
For i = 1 To Table.Rows.Count
If Table.Cells(i, 1) = Val1Occurrence And Table.Cells(i, Val2Col) = Val2 Then
iCount = iCount + 1
End If
If iCount = Val1Occurrence Then
FindNth = Table.Cells(i, ResultCol)
Exit For
End If
Next i
End Function
Bookmarks