Comparing Records in same column and with other columns

[mfulara]

I want to find and create a new column for the records in which Item Code is the same and Location is different, and then compare the value of Days w/o Consumption column for that case. The most value should get the least value's Location name.

[TimN · Accepted solution]

Something like this may work...

[mfulara]

Thanks tim it works.