Duplicate values in multiple columns [Solved/Closed]

Posts
2
Registration date
Saturday November 5, 2016
Status
Member
Last seen
November 5, 2016
- - Latest reply: M3TM3T
Posts
2
Registration date
Saturday November 5, 2016
Status
Member
Last seen
November 5, 2016
- Nov 5, 2016 at 01:25 PM
Hello,
I'm looking for a formula for a case mentioned below:
Consider we have values in three columns



I need to find a formula which compare columns B and C, wherever values of B are repeated in C, return customer's number in D. for example. in first row, the main value is 0.5 which goes to costumer NO 1. the value of 0.5 is repeated for costumer 3 so I need formula print the value 3 (costumer NO) in column D
RED values are my desired answers
I am grateful for any help.

See more 

1 reply

Best answer
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
2
Thank you
M3TM3T, Good afternoon.

Try to use:

D2 --> =INDEX($A$2:$A$7, MATCH(C2, $B$2:$B$7, 0))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Say "Thank you" 2

A few words of thanks would be greatly appreciated. Add comment

CCM 5673 users have said thank you to us this month

M3TM3T
Posts
2
Registration date
Saturday November 5, 2016
Status
Member
Last seen
November 5, 2016
-
Hurrah
You are my hero. thanks a lot.
It works like a charm.