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 |
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) |