Recent content by sjoo

  1. Lookup Value With Multiple Conditions in Excel

    DGET() function Andy, You're right, the second is wrong answer for some cases. I think DGET() function is suitable for this case as you said. Because I had to hurry up going a chinese academy yesterday, I had not enought time to think over it. This morning , I tried the 2nd problem with...
  2. Lookup Value With Multiple Conditions in Excel

    How about my solution?
  3. Doing Linear Regression?

    How about Statistics Library ? Hello I know a simple and free c/c++ library for statistcal library. you can download this at Statistics Library by Sgt. Pepper FYI, the content of header file is as following: /* statistics interface -------------------------------------- */ /* return sum...
  4. Hello everyone, let me introduce...

    Hello everyone, I'm glad to join this forum and meet you. My name is Seung Joo,Kwag. I work for a mutual fund investment company in Seoul. For years, I've been at Wilmott forum. I've helped someone and asked helps at the forum At this forum, I'd like to contribute to this forum with my...
  5. Automating Calculation of Lagged Cross Correlations between Variables

    Hello, Lucas I'm new to this forum. On the way of browsing this forum, I've read your post. it's possible with only worksheet functions. but. it would take much time to build formulas & recalculate them. Instead of the formulas, i wrote it with vba plz the attached file. because of vba...
Back
Top