groups

Hi everyone, I am using =CHOOSE(RANDBETWEEN(1,2),"A","B") to randomly assign data into two groups A & B. But when I do for 120 contacts does not group them into two equal groups of 60, which is what I want. Instead, it will have one group with 68 and the other with 52. Does anyone know a...

I have 30 couples meeting each month for 7 months in groups of 3 couples(10 groups). How can they be arranged so they are always with different couples each month - no duplication?

I intend to categorize Employees in 4 Groups with in a Department as shown below:-

I have two groups of data that I want to calculate the combined median for.One group has 4,094 sales with a median of $573,139 and the 2nd group is 1,259 sales with a median of $2,023,814.How do I calculate the median of the combined groups?Thanks

Dear MrExcel members, I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me. I want to make groups of x amount of products from a list. Example list: 1A34 2B43 1B544 5C45 3A52 5B32 Now I want Excel...

Dear MrExcel members, I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me. I'm looking for a macro/vba code/solver solution for the following problem: I want to make groups of 4/5/6 products that are...

Dear all Excel Professionals, I am a total newbie to excel and wants to know if it is possible to have a auto generator for the grouping. I have 8 games, max. for 36pax (sometimes will be fewer to 18pax). I will have 4 groups to do the same game at the same time. I hope to make a auto...

Hi, I have a workbook which a lot of people will be logging on to just put their name next to an activity. As I don't trust their housekeeping skills and the sheet works best to a newcomer in a certain format I want a button that say 'Save and Close' that will do the following: collapse all...

Hey, guys.:beerchug: So, obviously, I stumbled upon something that I can't seem to figure out myself. I googled, read and watched a lot. But this problem seems to be a bit too specific to find a solution on web. 80 items. Each item has a different "value" relative to each other. I want to put...

Hey, guys. I have a bunch of shapes that I grouped together. I want to Show/Hide them with a macro. I tried ActiveSheet.Shapes("Group 1").Hide and that didn't work at all. Is there a way to hide the whole group or show the whole group or do I have to show/hide them all individually?

Hi All, i have a series of groups set up in excel id say around 20 and then there is further groups set up in 4 sets i want code to run when a group is expanded this is way out of my capability's do i need some form of class module

Hello, i'm trying to find the highest number in a specific group. Basically I have column A which is a period and column B which is a quarter. I want to only show the biggest quarter (B) of a period group (A) in C, kind of like this: Any ideas how I could accomplish this? I'm completely stuck...

Cells A1:A4 (group 1) contain the values 1, 2, 3, 4 Cells B1:B4 (group 2) contain the values 5, 6, 7, 8 Cells C1:C4 (group 3) contain the values 9, 10, 11, 12 Cell A6 contains my variable value - use for example 7. Cell B6 should contain the value "2", because 7 is in group 2. My question...

Hello, I'm new here, and I hope someone can help me. I have an analysis equipment that measure the HP (horse power) consumpted by an electric motor every 20 seconds during 3-7 days. So, I have a between 13,000 and 30,000 points in one column. The motor have 4 stages (lets use a 100hp motor)...

Hi all, My apologies if I am posting this in the wrong section. I am new to the forum (I am also fairly new to excel). I would like some help from yourselves if possible? I am fairly sure there is a simple solution, I just do not know it. I have a frustration with spreadsheets I have been...

Hi there! I want your help on how to execute this on Pivot Table. What I want is to put the ENG Sum to Row value, and upon clicking it, all the components (ENG_123, ENG_456 and ENG_789) will appear. Then the value for those components will be shown as well. If this is possible, please let me...

I need to solve the nnext issue (in worksheet or VBA - never mind). In the next column, I have something as: group group blank group group group blank group group blank group group group group blank group blank group blank group blank group group...

Assume I am having some clones of a sheet (copies of a sheet). How to work with those clones (format/modify data) at a single time? (through vba). What is the default way of doing it? and Is there a way to do it without working with the selection (suggested by the record macro). Thanks in...

Hi There. I have data that has been recorded every minute for several days. I have created a Group for each day that includes all the rows for that certain day. I am able to expand or collapse the rows (show or hide) so that I am only viewing certain days. I do this by pressing the plus/minus...

Hi. Situation: I am analyzing data of a courier company. The data is organised into rows with each row representing a delivery from pickup to destination. I now wish to understand performance of the couriers over different distances (delivery lengths). The total distance of each delivery...