-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
dedupe
-
B
VBA to Concatenate one column data in excel and dedupe additional line items
Hello, Apologies if this is already on here - I did a search but was not successful in finding anything that is exactly what I'm looking for (and my VBA knowledge is limited...) I am looking to take data I have in an excel spreadsheet and concatenate one column's data for a referenced "tag"...- Beth0331
- Thread
- concatenate dedupe excel unique range vba
- Replies: 6
- Forum: Excel Questions
-
K
deduping, formatting and counting the dupes
I have a need to dedupe a keyword list in Excel 2010. Easy enough. But some of the keywords have "" in them. First off how can I remove the quotes from every cell in a column? Then when I goto dedupe I need to count how many times a keyword was found to be a duplicate. The keyword list is...- kensavage
- Thread
- clean dedupe
- Replies: 1
- Forum: Excel Questions
-
P
Sort, dedupe, merge and format in excel
I need to send out a holiday email to our clients and have all their data in excel. Simple enough, but I need to create a field/column that shows who in my company the email is from taking into account that in most cases each contact needs to have more than one person appearing in the “from”...- parfm
- Thread
- dedupe marco merge
- Replies: 4
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Payment term and Cash flow (formula linked with costs)
- Started by Adfinance
- Replies: 43
Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I... -
Match to a list with wildcards
- Started by The Gent
- Replies: 29
Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet... -
Inserting text above first blank row then above third blank row etc.
- Started by Livin404
- Replies: 24
Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I... -
code to get students marks from source sheet to destination sheet.
- Started by rzml
- Replies: 22
hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I... -
Run VBA on all open tabs
- Started by Dannottheman
- Replies: 22
Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I... -
Functions to separate a string separated by commas
- Started by jeffdolton
- Replies: 22
Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...