Monthly Archives: February 2011

Seperate Windows for Excel 2007 in Win7

click the middle button – the wheel and you get another excel windowno need to change the regedit …works well at my computer:win764bit + office2007 Advertisements

Posted in Uncategorized | Leave a comment

find the value at A column corresponding to the maximum value at B column

quick memo and example: A B0 0.35 -0.12.0 8… … Index(a2:a65536,match(max(b2:b65536),b2:b65536,0)

Posted in Uncategorized | Leave a comment

EndNote attached file path problems

I got a new computer and copied the Endnote library from the old. Unfornately it can not open the attached files. The reason is the absolute path. I tried the Endnote official method and it does not work (probably I … Continue reading

Posted in Uncategorized | Leave a comment