Results 1 to 8 of 8

How to pick up the numbers from the data but not duplicate them by formula?

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    Australia
    MS-Off Ver
    Mac Office 2011
    Posts
    13

    How to pick up the numbers from the data but not duplicate them by formula?

    Hi Excel Wizards,

    I want to count how many sales we have made from different prices. E.g. in the attached spreadsheet, it shows that 1 sale is made by $20 and 2 sales are made by $40.

    However, how to use the formula to pick up the sales $amount without duplicate them (red colored)?

    Thanks
    Attached Files Attached Files

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