#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
I you only need to find it use a CF on col D with
Code:
=countif($d$1:$d$400,c1) A reference to use in a formula Code:
=INDEX($d$1:$d$400,match(C1,$d$1:$d$400,0))
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |