Hi all,
I need to calculate in the H6 cell the number of orders in which the postcode is not available, by using the DCOUNTA database function. I got a task to use DCOUNTA and not a COUNTBLANK function...
In criterion I may either use the ISBLANK function or look for the text with a zero length by using the LEN function.
Please help...
File attached.
addresses.xlsx
Bookmarks