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?
    2832 12
    Answered ✓ 2.8K 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 …
    15219 149
    15.2K views 149 comments Most recent by Jimrny Best Practice