Re: how to highlight duplicate text in columns?
bill <[email protected]>
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <trinity-357fe7d5-2657-4b77-b788-ed00eba0add9-1530507112586@3c-app-mailcom-lxa07> |
Thank you so much guys, and especially Andreas (If you are not teaching this stuff somewhere, you should be). This is exactly what i needed, and your instructions are spot on. It's a little more involved than with LibreCalc or Excl, but a small sacrifice as i so much prefer Gnumeric. Kudos to the list in general as well! Every time i post here i save a ton of time. I was actually considering doing a "copy" and "search" for each item in a long column. peace bill Sent: Sunday, July 01, 2018 at 2:58 PM From: "Andreas J. Guelzow" <[email protected]> To: [email protected] Subject: Re: how to highlight duplicate text in columns? Let's say that A1:A10 is the region of interest. Select A1 down to A10 so that A1 is the primary cell. Then choose Format->Cells->Conditional Formatting Click Edit Style and pick the Background Color Red, OK Select as condition "Expression x evaluates to TRUE". Enter as x: countif(A$1:A$10,A1)>1 and finish with tab click "Add" click "close" Any cells with duplicate value in A1:A10 should now be highlighted in red. Andreas On 2018-07-01 06:13 AM, Bruce Hohl via gnumeric-list wrote: I don't really know if the conditional format feature can do that, but you can use something like countif(A$1:A$10,A1) in another column to determine which cells are duplicates (i.e. count > 1). Then you could use conditional formatting on the countif() column. On Sat, Jun 30, 2018 at 5:41 PM, bill <[email protected] > wrote: Hi all, I'm thinking this would fall under conditional formatting, but have not been able to find the option i need in the program or manual. I need to search a single column containing some 12,000 rows of text and highlight any duplicates without removing anything. Any help much appreciated! peace bill _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list