Hi,
I was wondering whether there were any limitations on using a Dcounta, currently I have seven filters all working I try to add an eigth one but it does not work.
I have tried more than once, the code/formula's are exactly the same.
The only thing I can think of is that there is a limit like with nested IF's.
Please can any one confirm? If so does anyone know a work around.
Many thanks
I was wondering whether there were any limitations on using a Dcounta, currently I have seven filters all working I try to add an eigth one but it does not work.
I have tried more than once, the code/formula's are exactly the same.
The only thing I can think of is that there is a limit like with nested IF's.
Please can any one confirm? If so does anyone know a work around.
Many thanks