Results 1 to 12 of 12

Find the biggest 'downturn' in a column of positive and negative numbers

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2017
    Location
    Downunder
    MS-Off Ver
    Excel 2016
    Posts
    7

    Find the biggest 'downturn' in a column of positive and negative numbers

    Hello,

    I have a long column of various numbers, positive and negative.
    Is it possible to find out the value of the biggest overall loss in the column (i.e. the biggest downturn)?

    5
    4
    -3
    -5
    2
    -3
    11
    0
    -8
    50
    -8
    50

    In the above example I would like a return value of 9 (the biggest downturn as seen in A3 to A6).
    The column will always have an overall positive sum. I don't mind having an extra column of data if it makes things easier.
    Hope that makes sense. I've attached an example sheet.

    Any help would be much appreciated! Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] splitting positive and negative numbers from 2 column to 2 columns
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2016, 06:31 AM
  2. [SOLVED] Find consecutive 15 positive or negative numbers in a column
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 05:26 AM
  3. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  4. Replies: 3
    Last Post: 12-17-2009, 09:14 AM
  5. Replies: 2
    Last Post: 09-28-2005, 12:05 PM
  6. How to turn positive numbers in a column to negative numbers ?
    By Dbase Beginner in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 03:14 AM
  7. Replies: 3
    Last Post: 03-24-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1