pairs

If anyone could help me with this formula I would be super grateful.. Thanks in advance. This formula below works fine with the exception that I now require the formula to only count “one” if there is two inputs on each cell of the nine pairs (“W128 & W129” is what I call a pair for example)...

Hello Friends, Here is a sample data which will be not more than 5 rows Col A Col B PO # UNIT 316543 Sets 316546 Pcs 316547 Sets 316548 Pairs 316549 Dozens The formula should sort values in Col A based on Units in Col B Formula should look first at Sets than...

On Sheet 1, I have a master list of data, with corresponding attributes. Some data has more than one attribute, some has only one, and there is a possibility of blanks. Attributes can be repeated when assigned to a different name. I've posted some example data below, so we can all talk about the...

this is the question posted by another member in "Questions in Other Languages" https://www.mrexcel.com/forum/questions-other-languages/1099110-extract-tail-tail-combination.html that I'd translated here the last digit of any pairs of numbers in A:F matched the last digit in G, merged the...

Hi everyone, I would appreciate if anyone can help me. I am trying to write a code, which will find duplicates within two given columns. However, I need only "pairs" to be found - not all duplicates at one time. For example, if column A has 3 values of 50 and column B only two values of 50 -...

I need help on a UDF shared by shg https://www.mrexcel.com/forum/excel-questions/499657-kendall-tau-test.html Is it possible to add a check of data validity in the range r. For example, if the data is: <tbody> [X] [Y] 12 77 15 98 24 . 12 93 26 92 </tbody> Currently function...

I have a list of x,y co-ordinate pairs (x1,y1 x2,y2) that describe the two end points of vertices for adjoining polygonal cells. However within this list I have duplicates, as adjoining cells share vertices. Where the co-ordinate pairs are direct duplicates, obviously they are very easy to...

Please help me out. I have a column like below (location:column B): <colgroup><col></colgroup><tbody> M 255129 255173 1 C 347122 348458 1 C 255319 255352 99 M 631064 631067 3 C 631140 631141 6 M 255129 255173 1 M 255173 255207 4 M 255158 255207 1 C 255319 255352 99 </tbody> . . . I am...

Hi All, I think I have a simple task in excel that I need to undertake. I am looking to compare a row of numbers against a table of numbers and would like to analyse the number or occurrences of consecutive pairs. In the example I have provided there is a single row of numerical data spanning...

Hello, let's say I have a 40 unique IDs (A,B,C,....) I want to make pairs like AA,AB,AC...AZ, BA, BB, BC.... etc. I believe there would be about 780 pairs (40*39/2). Is there a formula that I can use to create these pairs automatically? Or do I just need to create a matrix and use...

Hello, I have a quite large dataset 72501 rows and 36 columns. An example is as follows: 10268|32999226|15351|10272|7662755||||||||||||||||||||||||||||||| 32999226||||||||||||||||||||||||||||||||||| 15351||||||||||||||||||||||||||||||||||| 10272|||||||||||||||||||||||||||||||||||...

Generate 3 digit training (pick3) Have one of the 10 pairs with consecutive digitios The ten = pairs = 01 12 23 34 45 56 67 78 89 90 Example 126 712 192 821 291 214 Note that the consecutive pair (12) had 6 formations Rotating in the 3 positions inside the pick3 From left to right is also...

I am posting this in lieu of an unanswered thread -- "VBA to List all Possible Pairs of X,Y Data in two Columns" https://www.mrexcel.com/forum/excel-questions/1038311-vba-list-all-possible-pairs-x-y-data-two-columns.html I have two columns of X,Y data. I need to rearrange them so that I get all...

I have the following X,Y Data in two Columns: X=4,8,2,1,9 (Column A) Y=3,5,1,7,8 (Column B) What I need is, on the subsequent rows, all the possible rearrangements of this data. That is, for example: 1st output: X=4,8,2,1,9 (Column A) Y=5,1,7,8,3 (Column B) 2nd output: X=4,8,2,1,9 (Column...

Hi all, I have cost centers in column A, and corresponding account codes in column B. I want to know how many different pairs are there, for each cost center and accounting codes. So something like, =IF(SUMPRODUCT(($A$1:A1000=A1)*($B$1:B1000)),… Thanks

Hello All, I have several column pairs of data. Each is a pair of columns with Date + Event. They go on in a table for 100s of rows and 100s of pairs of columns. Here's just an example of two column pairs (keeping in mind other pairs would continue to the right --> and the columns themselves...

The following task seems simple... I just hope it is possible I will break this down into pieces to see each step because it boggles my head when I try to build a formula all the steps at once. NOTE: it is okay if the steps have to be done in separate ranges. However I want to keep them in rows...

Hey guys - Need help here. kinda new here. I need a formula to identify pairs with a +/- 1. Example: I'm looking for a pair with value of 100 but the only thing I have is 97,98,99 and 101. I need a formula where 100 will still be matched with the values 99 and 101. Let me know if I'm still...

Construct all pairs with the difference of or distances = 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,21,22,23,24 , 25 From the beginning of 01 to 80 Example = distance of 4 04 08 08 12 12 16 (I.e. Up until 76-80 Another example distance of = 12 05 17 17 29 ...... Up to 78 to 80 Put on an...

Hi! I want to be able to group row 1 and 2, 3 and 4, 5 and 6 and so on. I have information on the first row of the pairs and want to sort the pairs according to that information and it is important that the second row of the pairs don't get dislocated when sorting. Does anyone know how to do...