LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb Deb is offline
external usenet poster
 
Posts: 102
Default formula to throw out high number and low number

I have 6 months of actuals and I need to throw out the month and the low
month then take the remain 4 months times 3 to come up with a years total
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to change scientific number to regular number or text Compare Values Excel Discussion (Misc queries) 2 August 23rd 07 06:10 PM
change the color of a number when it gets too high EJRI Excel Discussion (Misc queries) 1 September 1st 06 10:44 PM
countif formula to find the occurances of a number that is greater than one number but less than another steveo Excel Discussion (Misc queries) 3 July 8th 06 02:04 AM
How do I set up a formula to throw out the 2 lowest scores? Rineay Excel Worksheet Functions 1 June 15th 06 05:08 PM
formula that gives me a random number less than other number janiladewilly Excel Worksheet Functions 1 October 13th 05 03:22 AM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"