• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

List Items corresponding in a table with values repeated both horizontally and vertically

Danilão

New Member
I need a formula to automatically list all items related to the closest expiration dates.
 

Attachments

  • VALIDITY.xlsx
    11.6 KB · Views: 5
You're new, Danilão, so I gotta be nice :):
1) "Related" how?
2) The expiration date "nearest" to what?
3) And now that I'm looking at your worksheet, which of those several date columns are the "expiration" date?

You gotta define the question, senhor.
 
You're new, Danilão, so I gotta be nice :):
1) "Related" how?
2) The expiration date "nearest" to what?
3) And now that I'm looking at your worksheet, which of those several date columns are the "expiration" date?

You gotta define the question, senhor.
I filled it in according to what I need...
 

Attachments

  • VALIDITY.xlsx
    10.5 KB · Views: 6
Back
Top