Hi,
Please can somebody help?
The purpose is to get the Max of column C for each AssetID(column B) and then return whether its a Cross Arm or Pole but Id need to returnall values for Poles and Cross Arm if the highest occurs more than once per AssetID.
So just for the below example, the...