| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average with max
I have a table of numbers, some cells are blank, and I'd like to calculate
the average (excluding blanks). Easy so far... However some of the numbers are "spikes", and rather than discarding these, I'd like to set a value for them, to be included in the average. I could have a second table with an IF function replacing any numbers too high, but would prefer not to if possible Any help much appreciated Thanks heaps -Bryce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Threaded Mode
