Lowest Value if condition met

Hi

I wanna create the new column for the lowest value of NPriceC2 among the values that have the same value of PSlopeC2 such as above screenshot

In other words, I wanna find the lowest value according to the PSlopeC2

Please let me know how to do
Thank you so much

Question

Look for LowestSince function and use condition PSlopeC2 != Ref(PSlopeC2, -1)

2 Likes

Thank you so much awilson~~!!!!
It works

1 Like