+ Reply to Thread
Results 1 to 2 of 2

Retrive datas from a table if conditions are true

  1. #1
    Registered User
    Join Date
    04-10-2020
    Location
    Florence, Italy
    MS-Off Ver
    Office 2016
    Posts
    2

    Retrive datas from a table if conditions are true

    Hi All,

    Here is my situation:

    Capture.PNG

    As you can see from the screenshot, i have a table (the green one on the right) where i have a applied a conditional formatting. This conditional formatting is highlighting all the values >0 in the range >= B2 (the date inside the column header should be >= B2).

    What I'd like to do now is to create a table like the one in orange created as an example here where I'll have:

    - Unit Number Column: I'd like to have for every row (Country) the first value >0 where the column header (date) is >=B2
    - Date Column: I'd like to have the column header (date) in which the previous value it has been found.

    Does anyone have any idea how to do it?

    Thank you very much for your help and time

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,772

    Re: Retrive datas from a table if conditions are true

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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. retrive a list of data from a table
    By mehmetics in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-17-2017, 07:53 PM
  2. how to pick datas with multiple conditions
    By ant21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2015, 11:20 AM
  3. Retrive Value if multiple conditions are met
    By score in forum Excel General
    Replies: 2
    Last Post: 03-18-2015, 09:47 PM
  4. Change from checking if 2 conditions are true to if any of 4 conditions are true
    By tafoyavision in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 02:17 PM
  5. Replies: 1
    Last Post: 03-26-2014, 02:14 PM
  6. compare oracle table datas and excel datas
    By james94539 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2013, 03:48 PM
  7. Replies: 2
    Last Post: 05-16-2005, 05:06 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