Results 1 to 7 of 7

Excluding negative numbers and bringing back lowest postive number

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2009
    Location
    Leeds, England
    MS-Off Ver
    Excel 2003
    Posts
    13

    Smile Excluding negative numbers and bringing back lowest postive number

    Hi, I hope i am posting this in the right section.

    I have a range of cells A2:A85 and this contains positive and negative numbers, I want to create a formula to exclude the negative numbers and bring back in a different cell the lowest postive value? is this possible? I have been trying all day and its driving me insane!!!!!

    Excel novice!!!
    Last edited by Dancingqueen; 09-15-2009 at 03:41 PM. Reason: Advised by administrator

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