Hello.
I'd love some help with "baking" the indirect formula, as i've never worked with it before.
My formula is as follows:
=IF(COUNTIFS($X$100:$X$500;$AC3;$W$100:$W$500;">"&1)>1;"2";IF(COUNTIFS($X$100:$X$500;$AC3);"1";"0"))
I have a VBA macro for endusers to create a new row
Range("A100").Rows("1:1").Insert shift:=xlDown
I need the count formula to be intact even after users input new rows, or delete previous rows.
I'd love some help with "baking" the indirect formula, as i've never worked with it before.
My formula is as follows:
=IF(COUNTIFS($X$100:$X$500;$AC3;$W$100:$W$500;">"&1)>1;"2";IF(COUNTIFS($X$100:$X$500;$AC3);"1";"0"))
I have a VBA macro for endusers to create a new row
Range("A100").Rows("1:1").Insert shift:=xlDown
I need the count formula to be intact even after users input new rows, or delete previous rows.