• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. W

    Finding least sum of differences

    Hey Hui, Thanks for the quick reply. I read that page, and while I couldn't figure out a way to use Linest, I did learn about offset, which I hadn't known before. From the offset link I learnt about macros... and several hours later I have a macro that is redoing my manual method for each row...
  2. W

    Finding least sum of differences

    Hi, I have a rather large table (5760 rows and 10 columns) and another table of the same sort of data(1440 rows and 10 columns). What I need to do is find for each row in the smaller table, the row in the larger table which has the least sum of differences (ie. the minimum of "column 1, table...
Back
Top