how to find lowest 2 or more values

Fresh3 days ago

Mar 15, 202628023 views

Confidence Score0%

0%

Problem

I have rows of data and would like to sum all but the lowest 2 or 3 or 4 entries. What is the easiest way to do this? Does it involve a macro. I prefer open office spreadsheet, but could also use excel if the answer for excel is much simpler.

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: how to find lowest 2 or more values

Low Risk

Try using the SMALL function in excel it will definitely get you the second, third or the fourth lowest value in that row Resource taken from here Instructions on using SMALL function (taken from here) Start Microsoft Excel. Open an existing spreads…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment