4 Replies Latest reply: May 16, 2011 8:39 AM by Frank Carlsson RSS

    Load only "some" customers

      Dears,

       

      How are you?

       

      I've an important question for you guys.

       

      I have two excel spreadsheets.

       

      The Spreadsheet #1 have two collumns: The collumn 1 have the Serial Number and in the collumn 2 there is the Shop Name

      The Spreadsheet #2 have two collumns: The collumn 1 have the Shop Name and in the collumn 2 there is the Latitude and Longitude


      The problem is that some Shop Name's in the Spreadsheet #1 is not available at the Spreadsheet #2 and will never be, because it's not important for me.

      So I would like to show in a chart only the Serial Number and Latitude/Longitude of the Shop Names available at the Spreadsheet #2. Not all the Shop Names.


      Follow is on picture about what is happening.

       

      So, to resume, what I need is:

      How to show in a chart only the Serial Numbers of the Shop Name's available at the Spreadsheet #2? And not all the Serial Numbers!!!

       

       

      Bye