Untitled.jpgHello All, can somebody help me
i have to make a online Pareto Chart for check real time defect contributor in our production machine, I have an Database sheet of defect, i uses large =LARGE(B$4:B$15,1).....11 formula to make descending order of defects,Then i use VLOOKUP to match the defect with his contribution, But when the lookup value is same in entire range its give me only one value repeated again and again, is it possible to get all defect name from the entire range.
Thanks in Advance
Bookmarks