AnsweredAssumed Answered

Mining an excel file

Question asked by yomango on Nov 7, 2012


Mining an excel file


     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.