+ Reply to Thread
Results 1 to 3 of 3

How to find last purchased price of an item?

  1. #1
    Registered User
    Join Date
    03-20-2018
    Location
    Phnom Penh, Cambodia
    MS-Off Ver
    2007
    Posts
    1

    How to find last purchased price of an item?

    Hi,

    I have a table below:

    Date Item Cost
    1/1/2017 A 10
    1/2/2017 A 20
    1/3/2017 B 30
    1/4/2017 B 40

    A was last purchased on 1/2/17 so I would like to get the value 20.
    B was last purchased on 1/4/17 so I would like to get the value 40.

    How/what formula to use to achieve this? Thank you.

    Sochenda

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,094

    Re: How to find last purchased price of an item?

    Try this:

    D2:
    Please Login or Register  to view this content.
    Array formulas:
    H2:
    Please Login or Register  to view this content.
    I2:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to find last purchased price of an item?

    Enter formula 1 in D2 for Date and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Enter formula 2 for Value in E2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Format Col D as Date
    v A B C D E
    1 Date Item Cost Date Value
    2 1/1/2017 A 10 1/2/2017 20
    3 1/2/2017 A 20
    4 1/3/2017 B 30 1/4/2017 40
    5 1/4/2017 B 40
    6
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Max Price and Date Purchased
    By seash in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 01:14 PM
  2. Replies: 3
    Last Post: 09-12-2015, 10:42 AM
  3. Return the most recent cost when item purchased multiple times
    By VRTOM in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2015, 03:57 PM
  4. Replies: 6
    Last Post: 11-20-2014, 11:10 PM
  5. Replies: 0
    Last Post: 01-09-2011, 06:04 PM
  6. Formula to find an item that has the Highest Price
    By headley4ever in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-08-2010, 03:17 PM
  7. Look up item to find price.
    By gibbsmachine in forum Excel General
    Replies: 1
    Last Post: 12-02-2009, 02:24 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