Skip to main content
Data is similar format as attachedif "A" the values are same  or blank in across the month then "No"if "B" and  "E" the value varies across the month then "Yes"

I need formula to bucket as per the table attached

1 answer
  1. Dec 28, 2018, 9:20 PM

    hello srikant,

     

    Are there any rules to be able to build the comparison?  For instance, if the first column always has a value as in this example, then it's just a simple comparison of each value to the previous.  We would need to know more about the data to build a usable calculation. 

     

    Please consider sharing a packaged workbook.  Packaged workbooks and flows: when, why, how

     

    Thank you

     

    Patrick

0/9000