Comparing two values and inserting lowest date in new column

[puppy26]

Hi all,
I would like to do the following functions in the excel..

the function should compare two values in a same column and if the two values are same, it should compare two dates in a particular column and insert lowest date in a new column..

In the following examples, if the search finds Houston, then it should compare values in the column 5 and should insert lowest value in the column 6..

Looking forward for your kind response..[TABLE="width: 569"]
<tbody>[TR]
[TD]Col 1[/TD]
[TD]Col 2[/TD]
[TD]Col 3[/TD]
[TD]Col 4[/TD]
[TD]Col 5[/TD]
[/TR]
</tbody><colgroup><col><col span="4"></colgroup>[/TABLE]
[TABLE="width: 569"]
<tbody>[TR]
[TD]Houston[/TD]
[TD]01.06.2012[/TD]
[TD]29.05.2012[/TD]
[TD]120[/TD]
[TD]29.09.2012[/TD]
[/TR]
[TR]
[TD]Houston[/TD]
[TD]01.06.2012[/TD]
[TD]29.05.2012[/TD]
[TD]120[/TD]
[TD]27.09.2012[/TD]
[/TR]
</tbody><colgroup><col><col span="4"></colgroup>[/TABLE]
[TABLE="width: 427"]
<colgroup><col style="width: 107pt; mso-width-source: userset; mso-width-alt: 5229;" width="143"> <col style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;" span="4" width="106"> <tbody>[TR]
[TD="class: xl68, width: 143, bgcolor: transparent"]New York[/TD]
[TD="class: xl69, width: 106, bgcolor: transparent"]01.06.2012[/TD]
[TD="class: xl69, width: 106, bgcolor: transparent"]29.05.2012[/TD]
[TD="class: xl68, width: 106, bgcolor: transparent"]120[/TD]
[TD="class: xl69, width: 106, bgcolor: transparent"]29.09.2012[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 143, bgcolor: transparent"]New York[/TD]
[TD="class: xl69, width: 106, bgcolor: transparent"]01.06.2012[/TD]
[TD="class: xl69, width: 106, bgcolor: transparent"]29.05.2012[/TD]
[TD="class: xl68, width: 106, bgcolor: transparent"]120[/TD]
[TD="class: xl69, width: 106, bgcolor: transparent"]26.09.2012
[/TD]
[/TR]
</tbody>[/TABLE]

 

[smkyle]

Since dates are stored as numbers, you can just use the MIN() function.