0 Replies Latest reply on Nov 7, 2012 8:30 AM by yomango

    Mining an excel file

    yomango

      Title

      Mining an excel file

      Post

           Hello out there. I have an excel file with three workbooks. Each work book has info on near 45 citieslocal authorities, sporting authorities and charity board members. Each city (in a row) has more than one person being listed either as a mayor, council president, ceo, director,etc. Many of those persons hold positions in more than one city and more than one category (authority,sports,board member).  I need to cross the information using FMP, so I know how many positions a particular person holds. Any idea how to go about it? I will be receiving updates every three months, so I need it to work not just once. Thank you for your time.