duplicate

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

Hi there! I've been using Google Sheets for some years, and have just come back to Excel for the first time since 2007. I've just spent perhaps the better part of an hour trying to search for what I'm trying to accomplish, with no luck. Somehow I've managed to do it before a few times, but I...

Hi, I have a pivot table which lists football teams down column A (home team) and across row 2 (away team). The values in the pivot table are the game week that the fixtures will be played. From this, I've been able to create an Index Match which summaries the fixtures almost as required. The...

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

Good Afternoon, I am having some issues with a dataset that came from an outdated system our business used before I joined, they had recently moved to a new system when I joined and now I can see why! The data below relates to Customer Journeys, which lack a vehicle identifiable field (which...