Results 1 to 3 of 3

Excel formula for Create List more than 0 value

Threaded View

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Excel formula for Create List more than 0 value

    Dear Experts,

    Please find here attached sample workbook, where i am expecting the total count in cell F3 as 4 because there are 4 Unique Customers where the value of the sales either in column B or C is more than 0. Likewise expecting the output in cell G3 as unique customer names because the value in column B or C value is more than 0 and in cell H2 and I2 the total sales value from column B and C for the customer.

    I hope i have clarified my expectations as well I have given my expected output from column F to I based on data from column A to C. Request to you please do not hesitate to revert back in case of any further clarification.

    Thank you so much for your precious phase and valuable support.

    Sincerely,

    Neilesh
    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] Create an Excel Drop Down list with Search Suggestions ( Serachable Dropdown list )
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2016, 12:03 AM
  2. Create dropdown list in Excel that will only list unique entries
    By MissAudrey in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2015, 04:56 PM
  3. [SOLVED] Formula to Create a Partial List from a Complete List
    By slindfors in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 02:44 PM
  4. How to create drop down list in Excel where each list item is based on two columns?
    By matkiros in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2012, 08:50 AM
  5. Replies: 2
    Last Post: 01-25-2012, 12:27 PM
  6. Replies: 2
    Last Post: 04-07-2006, 02:35 PM
  7. [SOLVED] Does Excel 2002 have a List>Create List option under Data?
    By Jesse in forum Excel General
    Replies: 3
    Last Post: 05-20-2005, 09:06 AM

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