Extract duplicate data and corresponding cell information

**rduda** · 11-26-2013, 12:21 AM

I'm not sure which formula or macro needs to be used for my query. I have a spreadsheet that is a report of all employees who have full control access to a SharePoint site. What I want to do is send a targeted email to each site owner and in it have a list of sites/URLs they are an owner for. The list has thousands of rows and the columns are:

Site Name
Site URL
Owner - each row in this column has employee logon IDs separated by a comma. I think this would first need to be split into one cell per user

I want to extract a list of each employee logon ID showing the Site Names and URLs they are an owner for, without putting in each one as a match as there are 10,000 sites all with multiple owners.

Any help is appreciated!

**:) Sixthsense :)** · 11-26-2013, 01:27 AM

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).