highlight duplicates

Hi everyone! I am looking for a solution to a problem that I have, and I hope someone here can help me out! My issue is that I have a long column containing questions in text, some the same and some different, (at the moment 800 rows in a single column) with strings with more than 255...

Hi All, I've come to the end part of a wee project and am a little stuck. I need to compare the data in two rows and highlight both if the entire rows, with the exception of coloumn "A" are duplicates. The code will activate if "A" has a value. That then becomes the source row, checking...

Hi All, I am trying to highlight all duplicates within a single column (E) in Excel on a large set of data (nearly 300k rows) with columns going A-Q, my headers are in Row 1 and data starts in Row 2 I have tried to use Conditional Formatting, this works to highlight the duplicates but when I try...

Hi All Excel Guru's, My first post here so please accept my apologies if I am out of line. Question: (Worksheet attached) I have a workbook with two separate Tabs Tab 1 - Floor Plan: Master Warehouse Map with Locations Tab 2 - Damages : List of Damages in the warehouse I have identified...

Hello, How to Highlight two consecutive equal text cells in a table ? I have to find, identify and manually delete multiple rows of an extensive table with 5 columns, the search for consecutive identical rows is needed by the column "A" only, the other columns maybe not equal. I tried already...

I have a spreadsheet that has SKUs listed in first column and then the warehouse location and then a column for inventory (qty on hand, qty allocated, qty on order, qty backordered, qty future, qty available). Some skus are spread out among multiple warehouse locations so those SKUs are...

Hi everyone, I am having an issue using conditional formatting. I am trying to find cell values in one column that match cell values in a second column. once found the matching value is highlighted In the example; 1 and 2 in the first column would become highlighted. A B 1 0 2...

Hi Guys, I have a challenge which I am struggling with. I need to highlight duplicates in rages across multiple sheets in a workbook. There are 26 ranges which contain text values and the ranges are the same from sheets 1 to 10. Ranges are: D5:R5 D13:R13 D21:R21 D29:R29 D37:R37 D45:R45...

Hi all, I am working on an Excel 2010 workbook and have implemented the following tweaked code I found online. In essence it is a worksheet change event which highlights cells red when duplicate values are added to column A (which is a list of candidate names). Option Explicit Private Sub...