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.