Best Practice

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?

  Cinda.q

  08/26/21

  Accepted

  2832 12

  Answered ✓ 2.8K views 12 comments 0 points Most recent by Paul Newcome 08/26/21Best 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 …

  Paul Newcome

  05/20/22

  15219 149

  15.2K views 149 comments 17 points Most recent by Jimrny 05/20/22Best Practice