Look up cell values with mixed number and letters
I would like to know if there is a excel function that can identify other cells that have mixed numbers and letters entries.
For example, Cell C1 has an entry- 19:44:B5. In the 400 cells in column d, only one cell has the identical mixed number and letter entry.
Is there a function that can look up and show the cell in column d that has the identical entry in C1 of 19:44:B5.
Any help would be appreciated
Matthew
|