Look up cell values with mixed number and letters

Cardinal2 · #1 02-08-2013, 11:10 AM

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

Pecoflyer · #2 02-10-2013, 01:40 AM

I you only need to find it use a CF on col D with

Code:

=countif($d$1:$d$400,c1)

as CF
A reference to use in a formula

Code:

=INDEX($d$1:$d$400,match(C1,$d$1:$d$400,0))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and replace with mixed formatting	pogonoforysci1	Word	2	09-26-2012 09:16 AM
change values based on cell	ubns	Excel	1	05-21-2012 06:28 PM
Automatic, Dependent Cell Values	flackend	Excel	2	08-26-2011 07:01 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM