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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,114,590
Messages
5,548,897
Members
410,884
Latest member
schreiberralph
Top