Find unique values frequencies of data with condition

Hi Buddies,

I just want to find out the frequecy of unique number of certain data. Attaching the excel. I tried the array formula. But bit confused. Please help

---Yogi

Try this,
E5

=SUMPRODUCT(--($A$2:$A$100=$D5),--(ROW($A$2:$A$100)=(MATCH($A$2:$A$100&$B$2:$B$100,$A$2:$A$100&$B$2:$B$100,0)+1)))

copied down.

You can also see attached.
Hope this helps,
windknife