Results 1 to 5 of 5

Formula to return items from a list with a value greater than 0 and ignore blanks

Threaded View

  1. #1
    Registered User
    Join Date
    08-25-2017
    Location
    England
    MS-Off Ver
    2016
    Posts
    36

    Formula to return items from a list with a value greater than 0 and ignore blanks

    Hi People

    I need some help with what will no doubt be a simple fix, but its not coming to me.

    In the sheet I have uploaded, in column B there are a list of fictional names, and in Column C there is a list of values between 1 to 10.

    I need a formula that will look up the list, and return all values greater than 0 and ignore the blanks.

    I have manually written what is would ideally look like in column E & F.. In reality the list of names will be in the hundreds and used daily.

    I cannot apply a filter to the data and sort it that way as in reality they data is pulled using a formula and changing the order breaks the rest of the process.

    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. [SOLVED] Return last numeric value in a row (greater than zero; ignore errors)
    By Luis Ah-Hoy Jr. in forum Excel General
    Replies: 7
    Last Post: 07-02-2018, 03:52 PM
  2. Excel Formula To Return Values in List without Blanks
    By bjohnsman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2016, 02:22 PM
  3. Search Through a Column to Find Match, ignore blanks return Value
    By lmc2016 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2016, 11:39 AM
  4. Formula to return unique value and ignore blanks..
    By tangmere.milli in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2015, 10:45 AM
  5. Replies: 2
    Last Post: 11-03-2012, 02:53 PM
  6. Ignore blanks when sorting a list
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2010, 09:29 AM
  7. Validation List ignore blanks (formula)
    By portmontreal in forum Excel General
    Replies: 2
    Last Post: 07-16-2009, 02:52 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