Best Practice

Archives for June 2020

Discussion List

  • Can you use 2 match criterias in an index/match formula?
    In Best Practice
    I am looking to structure an index and match formula, but it needs to match two columns of data and having some troubles. Is this possible or will I need to create a work-around with a Join function in another column?
    Accepted
    1181 12
    Accepted Answer 1.2K views 12 comments Most recent by Paul Newcome Best Practice
  • Formulas for Calculating Time
    In Best Practice
    I have decided to create a post that consolidates all of the different time based solutions that I have put together. Some of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through …
    8898 115
    8.9K views 115 comments Most recent by Paul Newcome Best Practice