Posted to microsoft.public.excel.worksheet.functions

JAIrvin

external usenet poster

Posts: 1

Trying to subtract the two lowest values from a row of numbers

I'm trying to come up with a formula that will let me add all but the lowest
two values in a series (row) of numbers. I can add all but the lowest by
using the MIN function to find the lowest value (and then subtract it from
the sum of all the values), but I can't figure out how to find the second
lowest value.

Any help would be appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Lowest two values	Muz	Excel Worksheet Functions	4	July 29th 08 08:41 AM
display lowest values	climate	Excel Worksheet Functions	6	December 13th 07 06:05 AM
taking out lowest 2 values	georgette	Excel Worksheet Functions	4	January 10th 06 03:13 AM
Lowest numbers	One-Leg	Excel Discussion (Misc queries)	7	May 26th 05 08:06 PM
how to subtract the very next LOWEST number	maxkofe	New Users to Excel	2	December 5th 04 06:06 PM

All times are GMT +1. The time now is 08:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us