+ Reply to Thread
Results 1 to 8 of 8

pull the data by unique ID

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    pull the data by unique ID

    Hi Experts,

    I have file with two tabs, 1st is the Raw data and second one is Result, I need three formula in result tab, 1st is most recent time will be show of this unique product product, there are many products of same Id I need most recent time of this ID, second formula I need most oldest kgs of unique ID in last 30 days, Third I need most oldest kgs of unique ID in last 90 days, I have attached screenshot and also excel file.

    Thanks in advance.

    Farhan
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: pull the data by unique ID

    Hi, anyone here for help?

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: pull the data by unique ID

    Please add expected results to your file.

  4. #4
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: pull the data by unique ID

    like this pls check attachment
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: pull the data by unique ID

    Two points:

    22 August is > 30 days from Today

    and

    most recent kgs of unique ID in last 90 days is surely the latest date i.e 23 September?

    and 20 June is > 90 from Today

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: pull the data by unique ID

    You need a change to the criteria "most oldest kgs of unique ID in last 30 days". 9/23/2017 - 30 days is 8/24/2017. The most recent date for Product ID 10800001 is 8/22/2017 which is 32 days back.

    Nothing qualifies.
    Dave

  7. #7
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: pull the data by unique ID

    this raw data is only demo for understanding, I only need formula which I have mentioned in sheet

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: pull the data by unique ID

    I certainly agree with Dave in that it is easier to help if the sample data and expected results actually agree.
    The following array entered formulas* seem to be what you are looking for, although they are not going to yield the expected results from the data provided.
    In B3 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In C3 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In D3 and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    *In each case select the cell in row 3 of the given column,
    Paste the formula into the formula bar,
    Simultaneously press the Ctrl, Shift and Enter keys,
    Double click the fill handle.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. How to pull unique data from another sheet
    By Luk3y in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-14-2017, 09:23 AM
  2. [SOLVED] Pull data into a unique table using VBA?
    By ccastell88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2015, 08:31 PM
  3. [SOLVED] Pull data into a unique table?
    By ccastell88 in forum Excel General
    Replies: 3
    Last Post: 08-03-2015, 04:02 AM
  4. Replies: 3
    Last Post: 05-21-2014, 08:34 AM
  5. Pull data from HTML tag which is unique (tag within a tag)
    By gochel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2013, 08:54 PM
  6. Replies: 5
    Last Post: 01-11-2013, 04:22 PM
  7. Replies: 6
    Last Post: 09-12-2011, 12:51 PM

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