+ Reply to Thread
Results 1 to 3 of 3

Rank results only when they meet certain criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    08-15-2011
    Location
    Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    Rank results only when they meet certain criteria

    Hi all,

    hope you can help me with the following:

    In my sheet costs per product a year are calculated. Based on this we can check if a certain product may be offered to the customer. But not all products are valid for our customers. So, in case the nr of orders is lower than x, the costs for product y may not be shown. But product z needs to be shown because the nr of orders fit.
    This makes that based on the nr of orders entered, only a few products remain. Those need to be ranked from cheap to most expensive.

    Any idea how to solve this?

    Thanks in advance.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: Rank results only when they meet certain criteria

    Please upload example workbook with some different inputs and desired outputs.
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    08-15-2011
    Location
    Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Rank results only when they meet certain criteria

    ok, attachment added to post
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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