Skip to content

Instantly share code, notes, and snippets.

@crowdmatt

crowdmatt/unique-excel-columns.xls

Created April 23, 2013 00:16
Show Gist options
  • Save crowdmatt/5439753 to your computer and use it in GitHub Desktop.
Save crowdmatt/5439753 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
unique-excel-columns.xls
=SUMPRODUCT((E2:E4106<>"")/COUNTIF(E2:E4106,E2:E4106&""))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment