How do I average a list and then find where the average falls within
the list without creating a circular reference. ie

1
2
3
4
average=2.5

so if I sort by that I would get
1
2
2.5
3
4

But excel returns a circular reference if I sort with absolute
cells.

If I sort without absolute cells it averages anything above where the
original average falls. ie

1
2
average1.5
3
4

BG