Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average a List and sorting
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average a List and sorting
Fix the value of the AVERAGE formula (by means of Edit | Paste
Special) before you sort. You can give a coloured background to the average to help highlight it when you have sorted. Hope this helps. Pete On Dec 18, 10:15 pm, "Brandon G." wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average the last 7 numbers on a list | Excel Worksheet Functions | |||
Show average at front of list | Excel Discussion (Misc queries) | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
How do I add a list of times to get an average time? | Excel Discussion (Misc queries) |