Merenguito
New Member
- Joined
- Dec 30, 2018
- Messages
- 8
Hey guys
I have been looking for this for at least 3-4 hours and I give up. How can I format a column to highlight all duplicate number values, ignoring empty cells or cells with words, without using scripts? I want to use Google Docs with this and if I am not mistaken I can't use scripts. This is what I get: http://prntscr.com/m1ccgs, sadly cells like Yes are also highlighted. I am using this right now: =COUNTIF(L:L,L1)>1
Thank you, and happy holidays!
I have been looking for this for at least 3-4 hours and I give up. How can I format a column to highlight all duplicate number values, ignoring empty cells or cells with words, without using scripts? I want to use Google Docs with this and if I am not mistaken I can't use scripts. This is what I get: http://prntscr.com/m1ccgs, sadly cells like Yes are also highlighted. I am using this right now: =COUNTIF(L:L,L1)>1
Thank you, and happy holidays!