Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-08-2013, 11:10 AM
Cardinal2 Cardinal2 is offline Look up cell values with mixed number and letters Windows 7 64bit Look up cell values with mixed number and letters Office 2007
Novice
Look up cell values with mixed number and letters
 
Join Date: Feb 2013
Posts: 10
Cardinal2 is on a distinguished road
Default 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
Reply With Quote
 



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
Look up cell values with mixed number and letters Automatic, Dependent Cell Values flackend Excel 2 08-26-2011 07:01 AM
Look up cell values with mixed number and letters How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Look up cell values with mixed number and letters Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft