View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VoicQn VoicQn is offline
external usenet poster
 
Posts: 2
Default multiple rows need distinct value and adjacent row

Hi, I'm new to the power of excel and need to compare a row of data to find
its unique value and keep it with the adjacent row. Here is what I have:
Feature DID
7775552323 7775332121
7775552323 7775332121
5556385698 5552229822
4445289639 4442229822
8884561289 7775339822

I need to find the unique value in the Feature column and keep the adjacent
DID column data...is this possible? And could you try and explain it simply?