Results 1 to 10 of 10

Find negative numbers in a table and return the value and corresponding text

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    Find negative numbers in a table and return the value and corresponding text

    Hi

    Hopefully somebody can guide me in the right direction..

    I have a table with 2 columns:

    Column A always contains text
    Column B always contains numbers
    The table does not have a fixed amount of rows and will be continually increasing over time

    I want a macro that will search the table from top to bottom for the first set of values with a negative number in column B, then return that set of values (Column A & Column B) to any 2 cells in the spreadsheet (lets say A1 and B1)

    So for instance using the attached example the macro will find the values 'Text 2' and '-0.1' and put them into the cells A1 & B1.

    If no negative values are found then I want to simply exit the macro.

    Thanks in advance!
    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. Replies: 3
    Last Post: 01-12-2017, 03:54 PM
  2. Replies: 4
    Last Post: 01-18-2015, 04:52 PM
  3. Replies: 3
    Last Post: 09-15-2014, 07:56 PM
  4. Find lowest value from 4 numbers in various cells and return text
    By mheinmiller in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2014, 05:32 AM
  5. [SOLVED] Having two date return number but exclude negative numbers
    By redjayhawk11 in forum Excel General
    Replies: 5
    Last Post: 12-31-2013, 06:34 AM
  6. Return zero for negative numbers.
    By pdmkh in forum Excel General
    Replies: 1
    Last Post: 01-20-2011, 07:53 AM
  7. Find, return string address in a range of cells with numbers and text
    By Vera22 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-09-2007, 08:37 PM

Tags for this Thread

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