|
PureBytes Links
Trading Reference Links
|
Why don't you write a user-defined function in VBA ? Shouldn't be too hard
- of the order of "one weekend plus a decent supply of coffee"
hard. Google for
excel user-defined function vba
and you'll get a lot of pointers to get started.
Regards,
Stefan
At 08:30 16/07/03 -0700, cwest wrote:
Here’s another tough thing to do in Excel (for me at least) that perhaps
someone knows how to address. I’m loading transactions (trades) into
excel and I’d like to build a column of unique symbol names, and sort
them. I tried the unique filter feature; but that doesn’t seem to be
reliable. It allows a few duplicates. I’ve tested that at some length.
A function like this would be good (Mr. Gates) ☺.
=unique(range1, range2, sort –a).
Any suggestions how to do this would be greatly appreciated.
Thanks in advance
Colin West
|