Hi,
I have a sheet where I'm wanting to count unique values in column A where Column B is not blank or is greater than zero. Please see the attached sample file will hopefully make it easier to understand.
I realise I could achieve this with a pivot table, but ideally I'd like a formula as it would makes things a lot easier for me with other tasks I have on the real sheet.
Any help or advice would be great!
Bookmarks