### Count Distinct in Excel

To count the distinct value of a list of data, you can try the following functions (Assume the data are in A1:A30000, you cannot use A:A in this function):

=SUMPRODUCT((A1:A30000<>"")/COUNTIF(A1:A30000,A1:A30000&""))
{"ft_lang_label":"__label__en","ft_lang_prob":0.80668503,"math_prob":0.9607576,"size":310,"snap":"2021-43-2021-49","text_gpt3_token_len":102,"char_repetition_ratio":0.18627451,"word_repetition_ratio":0.0,"special_character_ratio":0.3935484,"punctuation_ratio":0.2,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9716404,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-10-16T11:28:32Z\",\"WARC-Record-ID\":\"<urn:uuid:92d025f0-2820-4cab-bcb7-8ffcca83230b>\",\"Content-Length\":\"92127\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:cef6c3e4-787e-4544-afa7-972afe5acc9a>\",\"WARC-Concurrent-To\":\"<urn:uuid:3557fd2e-71e5-4746-8f40-7fc023090690>\",\"WARC-IP-Address\":\"142.250.188.51\",\"WARC-Target-URI\":\"http://blog.mikeyam.com/2009/11/count-distinct-in-excel.html\",\"WARC-Payload-Digest\":\"sha1:2CS35GRRZTWAESR4ZWPGFV5WZ3GNLZTM\",\"WARC-Block-Digest\":\"sha1:6MUQYMGYTB7HIB6K537E4BOKI6BSJKAD\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-43/CC-MAIN-2021-43_segments_1634323584567.81_warc_CC-MAIN-20211016105157-20211016135157-00086.warc.gz\"}"}