Ask a questionM3TM3T2PostsSaturday November 5, 2016Registration date
November 5, 2016
Last seen - Last answered on Nov 5, 2016 01:25PM
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.