-
To simplyfie bentleybob's suggestion you can have a look at this add-in: http://www.mrexcel.com/chal/pareto.zip All of the formulas in B are =RAND() functions. Click the checkbox to recalc, and a whole series of dynamic range names cause the chart to redisplay sorted values. It also make it possible...
-
Steve Sorry, I'm not with you? Was there not a solution on the website I gave you? Remember to look for duplicates across multiple columns you will need to concatenate the data, possibly in a helper column, so for example, in column D enter =A1&B1 and test against that. e.g your data would look...
-
Steve The first one is surely a duplicate also? (of the last one) There are many ways of identifying duplicates. I would point you to this site which lays out many options. http://www.cpearson.com/Excel/Duplicates.aspx