Forum Discussion

  • anupambit1797's avatar
    anupambit1797
    Iron Contributor
    Oct 26, 2023

    Thanks rachel , seems this Formula builder , is the key , which our IT desk block for use 😞

     

    Can you please provide some more logic for the same without using LET( say INDEX,MATCH,XLOOKUP, FILTER or IF functions?)

     

    Thanks again 🙂

    Br,

    Anupam

    • rachel's avatar
      rachel
      Iron Contributor
      Oct 26, 2023

      anupambit1797 

       

      Hi,

       

      I think COUNTIFS function is more suitable in this case. it works on an older version of Excel and it doesn't need array formulas.

       

      I attached an updated Excel.(BLER_CALC_27Oct.xlsx)

Resources