Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop 2 high and 2 low - help!
Hello-
I need to take 7 numbers (each in separate cells) (they could be the same), drop the 2 highest and 2 lowest and then add the remaining 3. Can you help me? 4 3.5 5.5 4.5 4 3 5.5 ===== Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop High and Low before calculation | Excel Discussion (Misc queries) | |||
can i export a high resolution chart from Excel | Excel Discussion (Misc queries) | |||
High bars | Charts and Charting in Excel | |||
Refreshing drop down cell values... | Excel Worksheet Functions | |||
Categorize drop down list | Excel Worksheet Functions |