Need to compare first 3 letters to all cells in the same column [Closed]

Report

smikey

Posts: 1
Registration date: Thursday July 30, 2015
Status: Member
Last seen: July 30, 2015

- Jul 30, 2015 at 01:48 PM

Help!
I am trying to see if there are similar email addresses in column 1 rows, and I need to compare it to column two rows to see if the first 3 values match anything else in the same column. I also want to some how view the matching cells as well. Please help :)

Need to compare first 3 letters to all cells in the same column
How to make 3 lines in one cell in excel - How-To - Excel
Comparing cells and in multiple columns ✓ - Forum - Excel
Comparing the two names respective of Upper & Lowercases letters ✓ - Forum - Excel
Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel
Compare 3 Columns excel ✓ - Forum - Excel

Need to compare first 3 letters to all cells in the same column [Closed]

Your reply

Subscribe To Our Newsletter!