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))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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