duplicate

I want to identify duplicates in column RandomColumn without using Group By - as this method will drop unused columns = let columnNames = {"RandomColumn"}, addCount = Table.Group(#"Added Index", columnNames, {{"Count", Table.RowCount, type number}}) in Table.AddColumn(#"Added Index"...

Full disclosure, I'm not a pivot expert - I created this table attempting to replicate a Crystal Report, and while I've been 99% successful there's a big formatting issue - the fund numbers keep repeating when I add a new column. The columns where this issue starts are calculated fields. I'm...

Hello, I've copied some samples from multiple locations and trying to piece together a workable sample that I can use... I've gotten lost along the way and need some assistance. What I'm trying to accomplish is having a Template I've created be copied with Values inserted from a table on...

Hi everyone, Thanks for reading my post, I'm looking to highlight duplicate values within 24 hours from the previous duplicate value. I'm using this but this is not what I want, I would like to replace NOW() with the timestamp of the previous duplicated value (if exist)...

Hello, I am trying to get rid of duplicate rows, but for some reason when I use delete duplicates it deletes all the data from columns other than A (even though I choose delete duplicates based on column A only). Could you please help me with this problem?

I am a beginner at Excel VBA. I just wanna know what code I am going to use for changing the value of the selected column if found duplicate. For example, I want to create a code that changes the duplicates found from their original name to their original name + "_01" (or something similar). It...

i have string data in excel more then 20k cells. in b1 i want to get the message if the all strings of a single cell are matched with any other cell in whole 20k like below. How can i do this... above you can see i have data in A and in B i need details like above. note: (there is no...

Hello, I have tried everything but cannot find a solution, I am really hoping someone can help with this. I am looking for a macro that will look for duplicates in the same row across all worksheets. Each worksheet has the same style as the one below, I just need a macro that will look in each...

I need a formula to get the result I manually typed in the last row. Smallest with no ties. Not the 2nd or more smallest.

I am unsure if this can be done, I have searched around and nothing quite his the mark. What I am trying to do is write something that looks at the date and time columns and if they are within 5 seconds of each other will look at two other columns within the data and if they are the same...

Hi All, on my Login Register my modify was working fine, until i got my duplicate validation working. now when i try to modify (edit) its registering it as a duplicate and it wont allow me to do it. Username is my unique column which the validation looks at. e.g employee "marpol" currently has...

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

Hey guys, Just wondering, I keep getting error 91 when running the below: Sub HighlightCellIfValueExistsinAnotherColumn() Dim ws As Worksheet Dim i As Long Dim j As Long Dim LastRow As Long Dim LastRow2 As Long LastRow = Cells(Rows.Count, "Q").End(xlUp).Row LastRow2 =...

I'm running into a unique situation dealing with duplicates. I have the following sheets: Sheet1: Sheet2: Sheet3: My current macro included in the workbook will compare any two columns within individual sheets and delete them. Sub delete() Dim x As Range Dim lstrw As Long Dim sh As...

Hi, I have two PowerPivot table that I want to combine and copy information to a third table, however the search criteria is empty as the two PowerPivot tables' amount of data changes from month to month. 1) I want the formula in column K for table 3 to be able to copy values from column B...

Hi, How can I compare duplicates in a non-continuous range? I would like to check if there are any duplicates values in a row, however only compare specified cells which are not next to each other. I have been able to do this with conditional formatting, however need it as a cell value too...

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