duplicate

Hello all, I am trying to automate a task that I regularly have to do at work however I don't have much experience using VBA/Macros so I was hoping someone could help? I will try my best to explain what I want to do in words but I have also got a mini sheet below which should make it a lot...

Good day Experts..please help me with this I have 3 Columns with single digit numbers, I need to know how many times each digit repit consecutively.ex 345 367 410 123 012 306 here we can see 0 repit 1 times (rows 5, 6), 1 = 2(rows 3, 4 and 4, 5), 3 1 times (rows 1 and 2) please help with the...

Hi, I have a first macro that compile data using relative and absolute reference recording. My second macro consolidate data My third macro clean the table after the consolidation. I can run them fine alone but one after the other one its not working. Call doesnt work. Application wait...

I am looking for a macro to highlight rows that have an appointment that occur on the same day at the same time. See table below for reference. 04/11/2022 11:00 AM 04/11/2022 11:00 AM 04/11/2022 10:00 AM 04/11/2022 9:00 AM 04/11/2022 8:00 AM 04/11/2022 10:00 AM 04/11/2022 8:00 AM

Hi all, I have the following setup (albeit in a much larger setting with multiple lines of emails): I want to merge my emails in A121 and A122 into one cell, like I have done above in A120. Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...

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...

Thanks in advance for any ideas you may have on my issue here: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same)...

Hey all! I'm trying to create a formula that can be used with conditional formatting to highlight changes, or duplicates, between 2 sheets, or 2 workbooks if that works better, on a row-by-row basis, for a week-by-week sales audit that we generate. I've tinkered with a bunch I've found online...

Hi All, I need to rearrange data so that it shows duplicates rather than only unique values. For example, data that shows qualifications: Category Subcategory John Bob Rich Microsoft Excel X X Microsoft Word X X I want to change it to: Category Subcategory Name Microsoft...

Hey all! Any help with this problem I'm bamboozling myself with would be hugely appreciated! So I have two different sheets I'm looking to compare and highlight duplicates of: Sheet 1 - Contains all current employee names in a "firstname*space*surname" format. It also contains a " [C]" to...

This has probably been posted but I have been looking for it confused for quite some time. I'm quite new to access - have written a few queries but am looking for a solution which doesn't seem to fit anything I have found as yet. I have a database with linked tables with 1 to many...

First thread and hoping someone can help. As part of a reward and recognition incentive at work this month, I’m running a type of raffle. As we work from different sites around Australia, we’re keeping everything digital and recorded using Excel. I’m wanting to be able to create a vertical...

Hello, I know it's against rules to cross post but I haven't been able to find a solution to my problem anywhere else. So I'm posting it here again. Please don't delete it :) I'm trying to achieve something seems really difficult to, I asked about on some other forums including Microsoft...

I created a report that pulls raw data from QuickBooks that shows the payments we've received from customers over a certain time frame and gives the detail on the payment itself as well as the invoice the payment was applied to. When we receive separate payments on different days that are...

Hello, I have a sheet of data in excel and I need to get the total minutes engaged per user. Most the users have a single row hosting their start and stop times. (Cell B1=UserName; B2=StartDateTime; B3=StopDateTime). I can get total number of minutes pretty easy from that, so no issue...

Hi guys I'm trying to find duplicate values (precisely duplicate email) in a single cell. I've got numerous of data that need to be clean by removing duplicates in a single cell. Then, i want it to be deleted directly. Appreciate if there is a formula/steps that can be use to solve this...

Hi All, Sorry not good with excel formula, can you help me construct formula how can I count how many duplicates we have in Column B per Name (Column A)? Sample result should be: Rose - 1 (2 Red) Joy - 1 (2 Purple) Angel - 2 (2 Blue & 2 Red)l

Hi everyone, I have a data set that is updated on regular basis by multiple users. Hence, the number of rows of this data set keeps on changing. However, the number of columns remain the same. The data set looks like following...

I am not well versed in VBA and have no idea where to start finding the issue here. I need to write a function that will take a 1 dimensional array as an input and spit out a new array with all the values sorted alphabetically and duplicates removed. This input "SourceList" column has text...

Hello all, I have been struggling with this one and couldnt find answers on google! Though am sure the answer is fairly easy. So i have a list of duplicate values in a column as below. A A A B B C I need an excel formula (non vba) which results "3". Because we have only A, B and C regardless...