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?

multiple rows need distinct value and adjacent row
 

Tell us what YOU think the results should be in the examples you've given.
That will help us understand what you are trying to do.
I suggest you re-post as a new question.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"VoicQn" wrote:

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?

multiple rows need distinct value and adjacent row
 

Oops, sorry about that.

I would expect to see:

Feature DID
7775552323 7775332121
5556385698 5552229822
4445289639 4442229822
8884561289 7775339822

the duplicate entry of 7775552323 has been eliminated, and the second column
DID stayed with 7775552323.



--
Respectfully,
VoicQn


"Gary Brown" wrote:

Tell us what YOU think the results should be in the examples you've given.
That will help us understand what you are trying to do.
I suggest you re-post as a new question.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"VoicQn" wrote:

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?

multiple rows need distinct value and adjacent row
 

A couple of different ways come to mind.
I would create a column of unique 'Feature' values and then use a vlookup to
a capture the 'DID' for each 'Feature'.

Assume 'Feature' is in Col A and 'DID' is in Col B.

From the top menu (assuming Excel 2003 or lower), select...
Data Filter Advanced Filter

Action: Copy to another location
List Range: Highlight Col A
Check 'Unique Records Only'
Copy to: Select Cell D1
Select 'OK'

Assuming the description 'Feature' is now in Cell D1...
In Cell E1, put the description 'DID'
In Cell E2, enter the vlookup formula...
=VLOOKUP(D2,A:B,2,FALSE)
Copy this formula down.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"VoicQn" wrote:

Oops, sorry about that.

I would expect to see:

Feature DID
7775552323 7775332121
5556385698 5552229822
4445289639 4442229822
8884561289 7775339822

the duplicate entry of 7775552323 has been eliminated, and the second column
DID stayed with 7775552323.



--
Respectfully,
VoicQn


"Gary Brown" wrote:

Tell us what YOU think the results should be in the examples you've given.
That will help us understand what you are trying to do.
I suggest you re-post as a new question.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"VoicQn" wrote:

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?