I’m stuck in a situation where i want to get the lowest and highest values that occur in column.
Let me explain:
I want to determine the lowest occurrence of a particular caller. In this case, B is my expected output. If, two values are the same, then we can select it alphabetically or any random method to pick one. I tried it like, created a VC,then counted the appearances then used MIN(list(VC1,VC2)) to get minimum of the VC, but it gives the number of occurances not the value of caller (B in given example)
Thanks in Advance.