Find positive or negative numbers? RRS feed

  • Question

  • Hello.

    How can i find positive or negative number within data column?

    i.e there is column with many numbers, positives negatives and zeros, how can i find the next positive or negative number?

    the Range.Find() method doesn't get Lambada expressions (x => x>0), and 'for' / 'while' not suit for that case...



    Monday, September 5, 2011 8:08 AM


  • There are several approaches depending on your scenario, eg

    A helper column with  =A1>=0

    AutoFilter, "is greater than or equal to", 0

    Peter Thornton

    • Proposed as answer by Liliane Teng Friday, September 9, 2011 8:38 AM
    • Marked as answer by Liliane Teng Tuesday, September 13, 2011 6:07 AM
    Monday, September 5, 2011 8:33 AM