Is it expected or is there a reason that Google Sheets uniquecount returns one more than the actual unique count for a column?

  • 1
    what formula you use and how your data table looks like - share a copy of your sheet – user0 Feb 23 '19 at 23:05
  • I would love to upload the spreadsheet, but I can not find how to do that on this site. meh – JEB Feb 24 '19 at 3:08
  • just paste the link and set sharing to: view – user0 Feb 24 '19 at 3:18
  • could be the blank cell. you can always do -1 or use:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.