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.
Re: Pulling list from 3 source lists
Crossposted at another forum. Please provide links.