Dear Sir, I want to get the duplicate values, sample attached.
M mu4you New Member Oct 11, 2017 #1 Dear Sir, I want to get the duplicate values, sample attached. Attachments chandoo help.xlsx 10.7 KB · Views: 7
N NARAYANK991 Excel Ninja Oct 11, 2017 #2 Hi , See the attached file. Narayan Attachments Book 1.xlsx 10.6 KB · Views: 5
N Naresh Yadav Active Member Oct 11, 2017 #3 Hi, Pls try this one =INDEX($B$1:$B$5,AGGREGATE(15,6,ROW($A$1:$A$5)/($A$1:$A$5=C1),COUNTIF($C$1:C1,C1))) Attachments chandoo help.xlsx 10.7 KB · Views: 3
Hi, Pls try this one =INDEX($B$1:$B$5,AGGREGATE(15,6,ROW($A$1:$A$5)/($A$1:$A$5=C1),COUNTIF($C$1:C1,C1)))