duplicate

=INDEX(Table!$B$3:$E$450,MATCH(A2&"Schedule 3"&"PLACE 1",Table!$E$3:$E$450&Table!$C$3:$C$450&Table!$F$2:$F$450,0),1)

Hello This is a list contains some values, I actually want this always randomly changed in new row without duplicates, I use this formula, this formula generate new random list than I manually sort and rearrange the list, and row wise its not duplicate, how I do this with formula, I attached...

I have the following. BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO I would expect each cell to be highlighted, however C35 does not seem to be affected. The theory behind...

Heyy there, My problem is : i cant remove duplicate column by single string I want script or marco or anythink (automation) to fix this problem Take look of screenshot of my solution what i need Thank you every one who fix that :D

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