4 Replies Latest reply on Mar 21, 2019 6:29 PM by Grant Vanderhorst

    Inner join not working

    Alex Martino

      Hello. I have two excel files.

       

      1) Has sales information on a daily basis, multiple transactions per day. I have created a formula that returns the month from date.

       

      2) Has expense information by day but not every day. I have created a formula that returns the month from date.

       

      I have joined these two data sets by month, BUT the result for the second file seems to have multiplied the results immensely. Why is this and what can I do about it?