Excel sheet clean up/ remove duplicates
Budget: $8 – $15 USD
This is a very quick job to clean up 8 excel sheets. We pulled addresses from a database.
- For the new UES Sheets (1-2units and 3 to 10 units) and UWS Sheets (1-2 units and 3 to 8 units) I need you to remove all addresses we have already send mailings to. I have a separate Excel sheet for UWS sent. For the UES sent, we have only sent to the addresses in bold so I only want those removed from the new sheets.
- For Chelsea and Village Sales, I need you to combine the sheets (creating one sheet for 1-2 units and another sheet for 3-10 units)and remove any duplicate addresses
-Make the top of the columns a pivot table in each sheet so I can organize entire sheet by whatever column I want.
- For all the new sheets if there is an address that comes up twice with the same sale date I want to combine into one line and just make the owners names as "John Doe/ Jane Doe"
- For the new UES Sheets (1-2units and 3 to 10 units) and UWS Sheets (1-2 units and 3 to 8 units) I need you to remove all addresses we have already send mailings to. I have a separate Excel sheet for UWS sent. For the UES sent, we have only sent to the addresses in bold so I only want those removed from the new sheets.
- For Chelsea and Village Sales, I need you to combine the sheets (creating one sheet for 1-2 units and another sheet for 3-10 units)and remove any duplicate addresses
-Make the top of the columns a pivot table in each sheet so I can organize entire sheet by whatever column I want.
- For all the new sheets if there is an address that comes up twice with the same sale date I want to combine into one line and just make the owners names as "John Doe/ Jane Doe"