|
What's a good freeware replacement for Excel? Specifically, I'm looking for something that can find and conditionally format duplicate entries.
|
# ¿ May 12, 2015 14:43 |
|
|
# ¿ May 19, 2024 06:34 |
|
LLJKSiLk posted:Google Docs Spreadsheets is almost identical to Excel except for some of the formulas are different, but there is usually a 1:1 replacement for most things. I'm looking through it right now and I'm not seeing anything to highlight duplicate entries. Am I missing it? neogeo0823 fucked around with this message at 15:25 on May 12, 2015 |
# ¿ May 12, 2015 15:10 |
|
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 |