Distinct Counting

[testsubjec]

Hi,

I have a SQL Query which pulls in information from our Warehouse System and the user is then able to set filters etc.

What I'd like to be able to do is do a Distinct Count on the filtered data but I cannot seem to be able to achieve this.

Please could you help.

Thanks

 

[Joe4]

Can you post your code, maybe a small example of your data, and your expected results?

 

[Aladin Akyurek]

The OP could try to adapt from the following example formula for distinct count, applied to an autofiltered range:

Control+shift+enter, not just enter...

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(O5,ROW(O5:O22)-ROW(O5),,1)),
  IF(O5:O22<>"",MATCH("~"&O5:O22,O5:O22&"",0))),
   ROW(O5:O22)-ROW(O5)+1),1))

The range which houses the relevant items is O5:O22, while O4 is supposed to house a header.

 

[kieran]

Would it not be easier to have the SQL return the distinct count with the data? It is a standard function within SQL.