set up a formula where if the difference between the angles is greater than 180? then add 360 to the larger angle? Then use a mod function to put it back to 1-360??
I don't think this can be done in a formula in 1 cell. So have a cell that calculates the range. Then next to your raw values transform the value more than 180? lower than the max. Then average and transform back to 1-360?.
Maybe someone else has an elegant solution. I would be interested too.
Keep Up with TechRepublic