How would I turn this formula into an array formula so it automatically populated when a new row is created?
I need the formula to count the unique properties in a row between cells Z-AC for every new row it creates.
For example, when row 24 has info entered it, I need the formula to automatically run:
=countunique(Z24:AC24). Any help here please?