Hi Ron,
Thank you very much for your assistance. Laurent Longre's Excellent MoreFunc
add-in and your Great Array Formula provides the required results. Very much
appreciated!
Cheers,
Sam
Ron Rosenfeld wrote:
Here's one method, assuming you have fewer than 256 entries.
Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr
NAME your data range: rng
Enter this **array** formula in some cell. Copy/drag to the right at least as
far as required. (It will return blanks if you copy too far, so no harm).
To enter an array formula, after entering the formula, hold down <ctrl<shift
while hitting <enter. Excel will place braces {...} around the formula:
=INDEX(UNIQUEVALUES((IF(COUNTIF(rng,rng)1,rng)), 1),
COLUMNS($A:A)+NOT(ISNUMBER(UNIQUEVALUES((
IF(COUNTIF(rng,rng)1,rng)),1))))
--ron
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1