duplicates

Hi all, I am working with a large set of data (5000 rows and columns A:AP). I am looking to find rows that are duplicate in their entirety, and then export them to a new sheet. So far I have used a formula to convert each row into a single string (=concat(A5:AP5), and from there I use...

Hi, I'm using this formula: =IFERROR(INDEX(A$3:A$30,RANDBETWEEN(1,COUNTA(A$3:A$30)),1),"") to randomly select 4 options from a list. Results are in cells A34-A37 and I would like to have no duplicates. Possible? Thanks Andrew

I have a list (column, say) of numbers. They will be recalculated continuously as part of an optimization routine. I need to generate another list (column) that counts the number of different duplicates in the original list, preferably ranked. (This is what the Tally command does in...

Hi! I'm looking for a formula to do the following: I have: <tbody> A B C D E F G H I 1 <colgroup><col width="68"></colgroup><tbody> 2040899 </tbody> <colgroup><col width="68"></colgroup><tbody> 54Z4 </tbody> 2 <colgroup><col...

Hi all I have done a macro to copy data from sheet2 to sheet 3 then remove duplicates, however it doesn't work, please could anyone help? Sub Reconcile() Dim LastRow AsLong LastRow =Range("A" & Rows.Count).End(xlUp).Row Sheet2.Select Range("F2:F" & LastRow).Select...

I have a spreadsheet with data in columns A thru F. In column A are contract #'s and in F are percentages. If there are duplicates contract #'s in A, and in column F one of the duplicate contracts is at 100% I need to delete the one that is not 100%. If neither is 100% I need to keep both. Is...

Hello, I am looking for a count formula for duplicates. For example: In column A I have invoice numbers: Column A Row1 10001 Row2 10002 Row3 10005 Row4 10001 Row5 10003 Row6 10001 I want to enter a formula in F1 that will take the value in A1 and find how many...

Greetings! I have a single column with 1,013,922 rows of values. There are 585,636 unique values in this column. I'm trying to determine how many times each of those 585,636 values occur in this column without entering a variation of the "COUNTIF(A:A,B2)" formula on each line of the 585k...

Hi everyone, Need help with a formula. Cell A1 = 1 Cell B1 = 3 Cell C1 = 7 Cell D1 = 1 Cell E1 = 4 Cell F1 = 5 Cell A2 = 1 Cell B2 = 2 Cell C2 = 3 Cell D2 = 7 Cell E2 = 4 Cell F2 = 1 I would like to count how many digits from cell range A2 through F2 appear in cell range A1 through F1...

I am working with a large data set (12 columns with 45,000 rows of entries) which is updated each day which in turn auto-updates a dashboard (within the document on another sheet) I have created to analyze this data. Currently, I am using the "remove duplicates" function to delete duplicates...

I have the following column values Input Account no Code 000005678 ABC 000005678 EDF 000001234 ABC 000001234 ABC Desired Output Account no Code 000005678 ABC 000005678 EDF 000001234 ABC Criteria Concatenate Column A and B (i.e...

Sorry that title is vague, I have a project where I am comparing Column D with Column J, Easy enough with standard CF rules, but I only wish to highlight the duplicates between column D and J, I am not concerned with/if there are duplicates with in each column (D or J) just if there are...

Good Days, Please advise a vba code to process the duplicates values clean task, If word/text in Cell A1 is equal to Cell B2 ,then Cell B2.clearcontents ...... If word/text in Cell A65536 is equal to Cell B65536, then Cell B65536.clearcontents Else, no change Thank you very much!

Is there a way to use the Countif function and remove duplicates Countif FG Component =Countif(C:C, c2) 22070090 300432 In the example below if I drag down the formlar , I will have the same number repeated. How do I remove it?

Is there a way to collect unique values from several columns (eg E4 to H1500) and put those values into a userform Combobox with no duplicates. like: E4 F4 G4 H4 row1 Byan PDIV RSI2 Row2 E5 F5 G5 H5 RSI Byan T8 RS and so on ...

Hi all, I have used this forum to find answers for years and always found what I was looking for without even having to post my question. But this time I am stuck, proably because I don't knwo what exactly to search for. Let me explain what I am trying to achieve first: I am analysing employes...

Hi, Is there a non VBA way to return all possible combinations without duplicates with the returned values in separate columns? Example below. Data in the first 8 columns / 10 rows, results starting in the 11th column. <tbody> No No No 1 No No No 1 No No No 1 No No No 1 Yes Yes Yes 2...

I have a spreadsheet like this: <tbody> UN Job RG AS TH SumDupes L217028 1 B 12 75 L217028 1 C 12 50 L217028 1 C 12 50 L217028 1 C 12 100 L217028 2 A 6 50 </tbody> I need to find duplicates: duplicate in this case means that the "Job", "RG" and "AS" are identical. So in...

ABL1VendorInvoiceReference2100001003422167058190052331L2L2=(INDEX(Sheet2!$L$3:$L$21835, SMALL(IF(FREQUENCY(IF(Sheet2!$K$3:$K$21835=$B2, Sheet2!$L$3:$L$21835), Sheet2!$L$3:$L$21835), ROW(Sheet2!$L$3:$L$21835)-ROW(Sheet2!$L$3)+1), COLUMNS($L2:L2)))) Above is what I am using currently. Searching...

Is it possible to count number of instances of duplicate and unique cells found from a varied range using a list of data from another sheet as a reference to on what to look for? My data will be varied with up to 20,000 rows and up to 10 columns Also the cells will contain both numbers and...