Find missing dates in column A

[jackt05]

Hi Everybody,

I have two columns

Date Cab No

1 4501
2 4501
3 4501
5 4501
1 3603
2 3603
5 3603

The cab no 4501 is absent on 4th & cab 3603 is absent on 3rd and 4th
i have more than four thousand entries with 50 cabs how to find with count if or any other formula the missing dates of the cabs

Please help

Jackt05

 

[jackt05]

Hi there one more thing

better the first one because it inserts entire row. I need to enter a complete row

sorry for wrong info.