+ Reply to Thread
Results 1 to 3 of 3

Execl formula return the lowest value

  1. #1
    Excel Lowest Value
    Guest

    Execl formula return the lowest value

    What formula do I use to return the lowest value whether numeric or character
    in the column?

  2. #2
    Bob Phillips
    Guest

    Re: Execl formula return the lowest value

    Surely lowest can only apply to numeric, in which case it is just =MIN(A:A)

    "Excel Lowest Value" <Excel Lowest Value@discussions.microsoft.com> wrote in
    message news:32B6E82C-1F37-4C5B-9E62-630F0144E17C@microsoft.com...
    > What formula do I use to return the lowest value whether numeric or

    character
    > in the column?




  3. #3
    Bernie Deitrick
    Guest

    Re: Execl formula return the lowest value

    You could use an array formula, entered with Ctrl-Shift-Enter:

    =INDEX(C:C,MAX((C1:C1000<>"")*(ROW(C1:C1000))))

    This will return the 'lowest' value from the first 1000 rows of column C - by which I took to mean
    the last entry in the column....

    HTH,
    Bernie
    MS Excel MVP


    "Excel Lowest Value" <Excel Lowest Value@discussions.microsoft.com> wrote in message
    news:32B6E82C-1F37-4C5B-9E62-630F0144E17C@microsoft.com...
    > What formula do I use to return the lowest value whether numeric or character
    > in the column?




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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