Sektormedia: Aaron's Brain

Delete Duplicates

Delete Duplicates
faq68-5446

A quick one this as the question comes up time and again.

Sort your sheet by the numbers you are trying to find duplicates on (in this instance we shall call it column A)
Then in a spare column type this formula

=if(A1=A2,1,0)
Then switch on auto filter and filter by 1 on your column with the equation
Then delete these 1s
This should leave you with a set of de-duped refs.

http://www.tek-tips.com/faqs.cfm?pid=68&fid=5446

HomeStar Runner Pumpkin Stencils

http://www.homestarrunner.com/ween_stencils.html

Expand Your Remote Desktop Capability

Did you know Windows XP's SP2 has a new ability
to have TWO Remote Desktop Sessions? Out the box, XP SP2 only has one.
You can enable the second one with a simple registry punch.

1) In the registry, drill down to:
HKEY_LOCAL_MACHINE \ System \ CurrentControlSet \ Control \
Terminal Server \ Licensing Core.
2) Create a new REG_DWORD value named EnableConcurrentSessions.
3) Set the value to 1.

You may have to reboot (or maybe not). And, voila! Instant double-team!

Why Did Constantinople Get the Works?

An MIT product called Haystack.
A total information manager.

http://haystack.lcs.mit.edu/index.html

MS just released the news of a similar product codenamed Istanbul.
I wish people would stop trying to tell me how to manage my information.