pairs

Request = separate pairs with repeating digits Ex = 01 21 = yes 01 32 = no The repeat can have 2 or 3 repeated digits The list has more than 4 thousand formations

Thank you for your help! Using excel 2007. need to combine like pairs and keep the results in one row. A1:AK1 holds the pairs -The pairs are generated by a formula and are not sorted. The format is general and there are no duplicates in this row. A2:indefinate2 (as far right as it needs to...

Hi, I need help with an excel formula. I have 2 lists, like: <tbody> A X B Y C Z </tbody> And I need to find all possible TWO pairs, without repeating any cell, like: AX + BY AX + BZ AX + CY AX + CZ AY + BX AY + BZ AY + CX AY + CZ ... I did get all possible pairs, like AX, AY, AZ, BX...

Hi All, Below is my code that I can't get to work... Sub find_dup_pairs() Dim i As Long Dim LastRow As Long LastRow = Range("B" & Rows.Count).End(xlUp).Row For i = LastRow To 1 Step -1 If Cells(i, 2) & Cells(i, 3) = Cells(i + 1, 2) & Cells(i + 1, 3) Then 'Range(Cells(i, 2)...

=IF(L90+M90>7,1,0) +IF(L91+M91>7,1,0) +IF(L92+M92>7,1,0) I want to use a formula to count a range of a pair of cells if they are greater than 7 when added together Possibly I wish to do this for 15 to 25 pairs of consecutive cells Is there an easier way than adding a row as above for each row...

Hi all :bow:, I've had a look on the forum, but cant quite find what I'm looking for. So hopefully you can help! Here is an example: <colgroup><col span="3"></colgroup><tbody> A B C Org1 Org1 Org2 Org2 Org1 Org3 Org3 Org1 Org4 Org4 Org1 Org5 Org5 Org2 Org1 Org2 Org3 Org2 Org4...

Hi All! It's been a while :) I need to find a solution in order to identify all the numbers which are inter-related. For example, 1 is linked to 2, and threfore 2 is linked to 1. So I have a chain 1-2. Then 2 is linked to 3, and 3 is linked to 2, and it is linked to 1, so I have a chain 1-2-3...

Hello everyone, I'm new to the forum, but I look forward to contributing to other peoples questions in the future! I currently have a question involving a scenario where I want to rank pairs of data while ignoring any duplicates in the data. What I am working with is located below. Column A is...

Hi, sorry for the title but i couldn t find a way to explain it... Basically i am making an excel to be able to make the most efective production calendar for my brewery... I have entries like the ones here under: <tbody> CookingDate Fermentator Name IsAvailableOn 03/08/2015 <tbody>...

The database is columns 'A' and 'B'. Numbers in column 'A' are related to numbers in column 'B' and this relationship needs to remain when the numbers are reorganized in columns 'C' and 'D'. I would like to rank the pairs of numbers into two new columns ('C' and 'D') with the numbers in column...

Hi. First time posting a help request. Spent endless hours trying to get this to work, but to no avail. Maybe someone can assist. Need to know the formula for counting how many times a certain number follows another given number in the same column. Per my example, how many times does the...