Created
September 14, 2018 18:14
-
-
Save ntrogers/6f56378bbf386b2c8927148f11f34b7b to your computer and use it in GitHub Desktop.
[Google Sheets] Useful Google Sheets formulas
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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