Quote:
Originally Posted by Steve_B
Thank you, Pecoflyer. Your solution is exactly what I needed. You are indeed an expert.
|
If your using Excel 2010 as in your profile, why don't you use the AGGREGATE function (Non array) and assuming your data is in column A!
=AGGREGATE(4,6,A:A)