pairing

  1. T

    Unique Pairs for 12 Players

    Hi All, I have a maths question I need your help with. I'm trying to generate 12 unique pairs for Badminton Doubles to not have the following: Player 12 not playing Player 4 three times (example Game 4, Game 5 and Game 6) Player 5 not playing Player 7, 8 and 11 more than once such as 7,8...
  2. P

    Select last used cell And it's Offset

    I would like to use "Range("G" & Rows.Count).End(xlUp)" to determine the last used cell in Range("G"), and select it AND its "Offset(1,0)". I am running into issues when pairing it with the Autofill code from Macro Recorder. See below: What I need to do (This is only an example, and does not...
  3. J

    Randomizer / Pairing

    I have a list of names and I want to randomly pair them in twos. How would I do this in Excel? Example: A1 A2 A3 A4 A5 A6 A7 A8
  4. F

    Substitution script with CSV input&output

    Hello dear Excel users! I got hung up on my lacking knowledge regarding Excel. My aim is to get a CSV input, which has several coloums, but only 2 is of interest: one which determines the type of data and a number value, which is to be copied unchanged. The output would have a completely...
  5. Y

    Conditional Standard Deviation

    I wish to calculate the standard deviation of Brand A Product 1-5 and Brand B Product 1-5. Is there any shortcut for this? I call this a brand pairing and I have 300 brand pairing to be done. Help is needed! :( <tbody> Brand Product Demand A 1 3 A 2 4 A 3 12 A 4 35 A 5 6 A 6 8 A 7...
  6. M

    Pairing two sheets in the same workbork

    I'm having trouble with pairing two sheets. I have two excel worksheets: Sheet 1 has keys and Sheet 2 has values. Is there a way to embed a form on sheet1, that will display the associated values for the keys in Sheet1 pulled from sheet2? So, if you click on A1 in sheet 1, the form will...
  7. B

    Linking/Locking/Pairing Two cells in same row

    Just a quick question. I am working a lot with the Ascend order function, and was wondering if there is a way to guaranttee that the cell references don't get mixed up. I am working on two different lists with mostly the same data, but the second list has a few entries omitted. In the process...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top