Pulling list from 3 source lists

  • I’m using Excel 2007 and I was hoping you could help me.

    I have 3 lists for each month in the quarter listing $ amount of taxable sales that was made per county. Obviously each month the counties can vary. I now want to make a list for the quarter for each county how much sales for each month and then total it up.

    I was wondering how can I make a formula that will go thru all counties on Mth 1 then check mth 2 check if its listed already if not add it then the same for mth 3.
    I want it to be a formula not VBA or Macro.

    Thanks
    David

  • Re: Pulling list from 3 source lists


    Crossposted at another forum. Please provide links.

    Where there is a will there are many ways. Finding one that works for you is the challenge!


    MS Excel MVP 2010-2016