Formula for Partial Duplicate match for 1 column

JJ EXCEL1234

New Member
Joined
Jan 30, 2018
Messages
11
I have attached a sample workbook of my problem.

I have a worksheet with prefilled data. I am adding new data to the workbook, but am unsure if the new data is already inputted. There is a column with unique identifiers - it is column D "instNumber". Column D has various formatting for the unique identifiers including: 1) year_instrument number, 2) instrument number. The instrument number can also be from 1 to 5 digits.

I would like to create a formula, for conditional formatting, that will highlight new rows of data that I input and existing data, if Column D partially matches for instrument number, with the number being from 1 to 5 digits.

Link to sample workbook: https://goo.gl/XYbk1z
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,109,450
Messages
5,528,819
Members
409,839
Latest member
akashsadhu
Top