Extract Minimum and maximum dates against values in adjucent column

[mchilapur]

Dear all,
I need to exract minimum and maximum dates against valies in Column A:A.
Ex: If i filter value 10, Minmum value is 5th Mau and Maximum is 16th june. I want these values to be populated in Couln C:C and D:D.

Similarly i need this data for each different value of Column A:A.

Please help me out with VBA caode.
Thanks in advance

[karedog]

You can use array formula, as described in :
http://blog.contextures.com/archives...x-if-in-excel/

or a VBA solution :

Please Login or Register  to view this content.

[mchilapur]

Works great......Thats a lot....

[karedog]

You are welcome, glad I can help.


Regards