pairing

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

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

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

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

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

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

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