Results 1 to 5 of 5

Return highest price paid row by part by customer

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Return highest price paid row by part by customer

    My report pulls the last two prices paid by customer for each part they purchase. I need a program to look at each individual customer by part. If it appears twice(last two prices paid), find the highest price and return that entire line and remove the other line. If it only appears once(they only bought it one time), return that entire line.

    Thanks for you help.
    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. Replies: 6
    Last Post: 05-28-2014, 07:24 AM
  2. Replies: 4
    Last Post: 08-15-2012, 09:49 AM
  3. Last Price Paid: VLoopup? Index/Match?
    By Excellerant in forum Excel General
    Replies: 4
    Last Post: 06-26-2012, 12:29 PM
  4. Replies: 1
    Last Post: 07-07-2006, 02:10 PM
  5. Return a price based on a customer from a drop down list
    By Pete Elbert in forum Excel General
    Replies: 7
    Last Post: 04-30-2006, 10:00 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