I'm trying to have an array formula in a macro. But its return an error. Cansomeone help me please.
Attached is my workings with a recorded macro. The formula in column "O" returns the results I require. My request is for a macro to the same result in column "N" or any "active cell" selected.
Your assistence would be appreciated.