Skip to content

Instantly share code, notes, and snippets.

@ntrogers
Created September 14, 2018 18:14
Show Gist options
  • Save ntrogers/6f56378bbf386b2c8927148f11f34b7b to your computer and use it in GitHub Desktop.
Save ntrogers/6f56378bbf386b2c8927148f11f34b7b to your computer and use it in GitHub Desktop.
[Google Sheets] Useful Google Sheets formulas
Conditional Formatting:
Highlight duplicates in row:
=countif(A:A,A1)>1
Add colons to MAC address:
=CONCATENATE(MID(F2,1,2),":",MID(F2,3,2),":",MID(F2,5,2),":",MID(F2,7,2),":",MID(F2,9,2),":",MID(F2,11,2))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment