Excel VBA to pull minimum and maximum date in separate table

Dear all,
I need VBA to pull Minimum and maximum date in the table shown in the attachment.
Input data is in Column A:B.

I know it needs to achieved using arrays and i am totally week at it..

Thanks

Why vba?

G7:
=MIN(IF($A:$A=H6,$B:$B))

G8:
=MAX(IF($A:$A=H6,$B:$B))

Both formula must be confirmed with Ctr+Shift+Enter(Array formula entry).

Select G7:G8 then fill to the right.

You could record the macro while you do the above to get vba code.

Output is not correct...Please review attached

You need the read it carefully.

Originally Posted by jindon

Both formula must be confirmed with Ctr+Shift+Enter(Array formula entry).

Select G7:G8 then fill to the right.