Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate negative numbers from stats
Hello,
I am tracking days for project completions. I do this my subtracting the start date from the completion date. The days of the uncompleted projects are negative numbers. Among other stats, I'd like to do averages on completed tasks. What's the best way to eliminate the negative numbers from the averages? Could this be done with a pivot table? I know a pivot table would do a lot of what I'd like done. Thanks for your help, Ellen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I eliminate negative values in a spreadsheet ? | Excel Discussion (Misc queries) | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
hOW TO ELIMINATE COL. ABC ROW AND ROW NUMBERS IN EXCEL SHEET | Setting up and Configuration of Excel | |||
macro to eliminate repeating account numbers | New Users to Excel |