Results 1 to 6 of 6

filtering and removing the rest except all the smallest available, please help!

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    london, england
    MS-Off Ver
    2013
    Posts
    4

    filtering and removing the rest except all the smallest available, please help!

    I want to ask if there’s any way to help remove those highlight in red by any function with the following criteria.

    When the period (i.e. date 1 and 2) are the same,
    - Keep the cheapest available (if price is 0, it means unavailable)
    - Keep all cheapest even when their price are the same

    date 1 date 2 supplier price
    01-Jul 02-Jul A US$16
    01-Jul 03-Jul A 0
    01-Jul 03-Jul B US$22
    02-Jul 03-Jul A US$15
    02-Jul 03-Jul B US$15
    02-Jul 03-Jul C US$18
    Attached Images Attached Images
    Last edited by zitafung; 07-30-2014 at 02:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding smallest value + second smallest value until exceeding a specific value
    By ployo60 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 07:25 AM
  2. sorting and filtering and removing hidden records
    By johnmerlino in forum Access Tables & Databases
    Replies: 3
    Last Post: 10-05-2010, 04:35 PM
  3. Macro : To find word and Select rest after this cell and delete rest
    By Zortabello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08:06 AM
  4. Filtering Sheet based on criteria - removing duplicates
    By rastaman69 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2008, 12:20 PM
  5. Removing (deleting, filtering) lines in a pattern . . .
    By Wayne Knazek in forum Excel General
    Replies: 7
    Last Post: 07-26-2006, 03:55 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