how to: If Statements: pull duplicate data between column b and Column C

%3CLINGO-SUB%20id%3D%22lingo-sub-2332899%22%20slang%3D%22en-US%22%3Ehow%20to%3A%20If%20Statements%3A%20pull%20duplicate%20data%20between%20column%20b%20and%20Column%20C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332899%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20small%20spread%20sheet%2C%20I%20have%20set%20up%20a%20duplicate%20function%20to%20be%20highlighted%20in%20red.%20As%20more%20data%20is%20input%20and%20the%20red%20text%20shows%20up%2C%26nbsp%3B%20I%20am%20trying%20to%20figure%20out%20how%20to%20get%20the%20row%20with%20the%20highlighted%20text%20to%20be%20cut%20out%20and%20moved%20to%20another%20page....any%20help%20would%20be%20greatly%20appreciated....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETedi_Sagal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2332899%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a small spread sheet, I have set up a duplicate function to be highlighted in red. As more data is input and the red text shows up,  I am trying to figure out how to get the row with the highlighted text to be cut out and moved to another page....any help would be greatly appreciated....

 

Tedi_Sagal

1 Reply
you can use conditional formatting that you can filter to identify duplicates but you have to manually filter them and cut and paste. Here's the tutorial for conditional formatting:
https://youtu.be/Ea_ACp5W8zI