Loop to assign values based on condition

[chullan88]

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

[BadlySpelledBuoy]

Is the sample data truly representative of the real data? i.e. column A is always grouped together and column B is always in ascending numerical order?
If so then you'd just need to check if any cell in A matches the cell below and if not then put Latest in C.

BSB

[Sintek]

Perhaps?

Please Login or Register  to view this content.

[chullan88]

Is the sample data truly representative of the real data? i.e. column A is always grouped together and column B is always in ascending numerical order?
If so then you'd just need to check if any cell in A matches the cell below and if not then put Latest in C.

BSB

Column A will not be grouped together always
Column B will always be in ascending order ( Corresponding to each item in A)

[chullan88]

Hi sintek,

The code works when the items in Col A are grouped but fails when they are mixed up.
Can you provide a workaround?

[Sintek]

Pls upload a sample file to make use of for testing.
This works even if items in col 1 are mixed up...

Please Login or Register  to view this content.

[jindon]

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

Please Login or Register  to view this content.

[Sintek]

Excellent code jindon...Very clean & simplistic...thanks for the lesson

[chullan88]

Excellent..works great...

[chullan88]

Thanks Jindon and sintek

[Sintek]

Tx for the rep...Although my code does produce same result, it is far inferior to jindons