Try Gaz's suggestion one more time. Make sure your data starts in row 2.
(It worked fine for me.)
Greshter wrote:
Cheers for the reply
In answer to your query Dave I see where you're coming from and your
solution would be the logical one - however I actually need to retain
all of those singleton records (we need to recheck them against other
attribute data which cannot be automated - it is a map related thing).
So in short I would want to keep both of those Aboyne singleton
records.
I guess you would just need a little manipulation with that macro to
help this materialise - you're probably a better judge of that than
myself
Gaz
Couldn't seem to get your one to work - just came up with zeroes in
columns D and E
Cheers for that - hugely appreciated
Mike
--
Dave Peterson
|