remove

I am populating data from a seporate workbook and there are duplicates that get transefered over in the process. I want to remove the duplicates, but keep the last entry. All the removal processes I've seen remove the first instance only, or require additional steps of adding columns to create a...

I can't use xlbb add-in since my company disabled add-ins. I have a list of companies that I need to clean up the duplicates. Some company names are very similar or have a comma or period in the name or some other extra value. How can I remove them easily. I think the best way would be if the...

Hello, I have two strings of letters (columns String A and String B) and I want to transform them into strings like the ones in Solution 1 and Solution 2 correspondingly. String A String B Solution A Solution B 7-6-1-3-4-2-2 DDDDDTT 7-6-1-3-4-2 DDDDDT 3-3-0-2-0-0 DDTDTT...

Hello, I have two strings of letters (columns String A and String B) and I want to transform them into strings like the ones in Solution 1 and Solution 2 correspondingly. In the case of String A, I need to remove any adjacent duplicate characters, so the string ZPDUU would turn into ZPDU...

Hi, Can anyone help with a macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black? Thanks.

Hi All, I'm trying to remove duplicates and sum values. I have table which is looks like that. item number client Date Quantity 167 C10000038 28/01/2022 00:00 3 600831 C10008630 27/01/2022 00:00 1 600831 C10008630 27/01/2022 00:00 48 600827 C10008630 28/01/2022 00:00 1 950114...

Okay, i have no idea what I'm doing. After some toying, i have =IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("@",A4))-1)," ",REPT(" ",LEN(A4))),LEN(A4)))," ") in order to extract email addresses from stuff like "Bhatia, Tulikaa <Tulikaa.Bhatia@domain.com>" My problem is that i...

Hello, this has been asked before but my problem is a bit different. I want to get rid of some words in a column using a Macro (or formulae) text revised text Text to remove This is a sentence containing keywords. For Analysis, for general. sentence,keywords,analysis,general is this is a...

Hi I have a query in Power Query like: Site id | Start Date | End Date | Value 1 | Value 2 | Value 3 | The date periods are random and dataset comes every month as a txt file. Newer txt often contain corrections of older ones but do not necessarily share start date or end date. My goal is to...

Hi, i wrote a macro that will Sum and Delete duplicate rows. The code works fine, however it seems to me that i wrote to much code for a simple task. Can you sugest a simpler approach please? Thanks. Option Explicit Sub test() Dim lrow As Long, k As Long, i As Long, q As Long...

Dear All, I was trying to add a date picker on my userform and I installed Sam Radakovits Date Picker Excel Date Picker — Sam Radakovitz. In the end I've never used it because I don't like it and also because I don't want to install it on all the PC of the users. My project worked on any...

I paste my current cryptocurrency exchange order into column A. I use several macros on it then clear the contents for the next trade. So the contents of Column A changes with every trade. The problem I am having is now Bittrex puts the Bitcoin symbol at the beginning of the number like the...

1 need 00001 help please-__- need help please-__- KXY247 with KXY247 this with this 35 major 35 brain fart major brain fart Column A is showing a string of what I need removed from Column B with the final result being Column C. I have about 33000 rows this needs to run on :) wish me luck...

Is there any VBA Or Custom Function or Formula which help in removing the prefix numbers and alphabets at the starting of each sentence. AB1RAW DataExpected Output21. TAS Balagopal – Export management – HimalayaTAS Balagopal – Export management – Himalaya32. Varshney & Battacharya –...

I have huge text data contains list of topics and course contents.I am facing a challenge to remove intro section numbers and session Numbers and much more to a normal text pattern. Individual removing them is taking a lot of time and effort. I need the help of Mr. Excel Experts in resolving...

I am very thankful to the Mr. Excel forum in providing right solutions. my data consists 70k rows and would be helpful if you Provide a solution through VBA Match every comma separated string of column C with Column B at each row level (C2 with B2) If found - it should be remove the word...

HI, I have seen multiple posts about removing old connections using VBA but they remove all connections. I have a sheet with 62000+ connections that have built up over time and would like to remove them and retain the 100 usable connections. Is there a way i can filter against the "Last...

=IF(C7="Rosemont University",E7*$P$28,IF(C7="Clayborn University",E7*$P$28,IF(C7="Branch College",E7*$P$28,IF(C7="Eastern Wisconsin University",E7*$P$28)))) My issue is that I can seem to remove False from my cells. Any help is appreciated

Hi Folks, I have a list of customers in column A. All of them start with "zz" which is simple enough to remove using... Range("A2:A" & lRow).Replace what:="zz", Replacement:="", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=True, _ SearchFormat:=False...

Hi all, I am trying to remove rows based on if a cell in column C is not blank for that row. Ive searched multiple threads but nothing is seeming to work for me. I have this one below that works great for removing rows where a cell IS blank. But I need to remove if the cell actually contains...