Hi,

I am trying to loop through two columns ( Col1,Col2) and based on a condition, to assign a value in Col3

Conditions
------------

1. For each item in Col1, against the highest value in Col2, "Latest" to be assigned in Col3
2. Col1 value should not be empty

A sample of what I am trying to achieve is shown below..

Col1 Col2 Col3
A 1
A 2
A 3 "Latest"
B 1
B 2 "Latest"
C 1
C 2 "Latest"


Thanks in advance