LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default How to find duplicate cells in Column a & retrieve column B

How to find duplicate cells in Column a & retrieve column B
A B C D E
1 abc cba =vlookup(c1,a1:a4,1,false) 2
2 cba€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€ ¦€¦€¦

What I want to do is retrieve the A value in E according to the value in D1?€ƒ

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FIND DUPLICATE TEXT IN A COLUMN!!!!!!!!! HERNAN Excel Discussion (Misc queries) 1 October 16th 06 10:38 PM
Find the first Value in a Row and Retrieve the Header for That Column efernandes67 Excel Discussion (Misc queries) 1 January 18th 06 10:23 PM
How can I find duplicate numbers within a column? Ima Bee Ginner Excel Worksheet Functions 1 January 18th 06 09:18 PM
How to find the duplicate text from a column or from a row? Yohan Excel Discussion (Misc queries) 1 August 15th 05 09:05 AM
How can you find duplicate numbers in a column? Alvin Excel Worksheet Functions 1 January 15th 05 11:24 PM


All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"