|
neogeo0823 posted:I'm looking through it right now and I'm not seeing anything to highlight duplicate entries. Am I missing it? There isn't one natively, because Google Sheets is a bit lightweight; scripting is an option (why a Googler used the thread to push add-ons without actually linking to a relevant one I have no clue). Also LibreOffice is an option and doing that works sort of the same (easier to web-search for conditional formatting; about the same but no obvious "quick" options, you'd probably use the conditional formatting window). dont be mean to me fucked around with this message at 16:29 on May 12, 2015 |
# ? May 12, 2015 16:25 |
|
|
# ? Apr 23, 2024 14:09 |
|
neogeo0823 posted:I'm looking through it right now and I'm not seeing anything to highlight duplicate entries. Am I missing it? I think if you add a column, you can use something similar to this: code:
|
# ? May 12, 2015 16:55 |
|
Sir Unimaginative posted:There isn't one natively, because Google Sheets is a bit lightweight; scripting is an option (why a Googler used the thread to push add-ons without actually linking to a relevant one I have no clue). It turns out there's an add-on in Google Sheets called Remove Duplicates which does exactly what I want. It takes a sheet, or a selection from a sheet, finds either just duplicates, just uniques, or duplicates/uniques as well as the original entry, and then gives you choices of what you want to do to them. You can highlight them, copy/paste them somewhere, delete them, and a couple other things. This is actually quite handy, now that I've tried it out.
|
# ? May 12, 2015 21:59 |