groups

I have a routine that imports a Microsoft project plan. That all works perfectly. I'd like to create some VBA code that would apply the "+" and "-" to collapse and expand groups based on the WBS code. I'd like a "+" by the 1, 1.1, 1.1.1, 1.2, 1.3 and so on depending on the indent level when...

Hi, I have an excel with many rows so I can't do this manually. In one of the columns there is a value of 0- 13 for each row. I would like to create another column to group these values into five groups - 1: 11-13 2: 7-10 3: 3-6 4: 1-2 5: 0 <colgroup><col span="3"></colgroup><tbody> ID...

Hi all, Can anyone help me please: I am trying to generate random lotto in 8 groups of 8 rows each. The aim is to have 8 groups with the following criteria. numbers appears only once per group; if 16 & 27 appears together in the same row in group 1, it does not appear together again in any...

I have a spreadsheet that contains names in one column (C) and email addresses in another column (D). Each person/row is a part of one or more of six groups. I have captured their group information in columns G-L which are titled simply 1-6, and then if a person is part of group 1 they get a 1...

I have a long list (several thousand) of record ids - see below. Each record id is associated to a name of an individual who belong to "n" groups for very good reasons. Hence a record ID can be replicated many times because the individuals belong to many groups. I wish to create a unique key...

Hello all my Excel Gurus! I want to count the number of segments, or groups of data, in this array. The results should be 3. (I think I might have to add zeros in the blanks) <tbody> <tbody> 20 85 65 65 20 22 </tbody> </tbody> Then add one more step into this. If I had...

Hello, I have data that is in sequential order. One column contains data that is either 1 or 0. I want to create a new column that numbers the groups of consecutive 1's. <tbody> 1 1 1 1 0 0 1 2 1 2 1 2 0 1 3 1 3 0 0 0 1 4 1 4 </tbody> What is the best way to...

Using Excel 97, I made a spreadsheet that has groups of names and other information. Each group is preceded by a single row in the group having a date. This is an example of the organization: <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom>...

I am working on consolidating several different employee groups. They are separated by different benefit rates. I have 25 different groups, each with 9 different rates. I am looking to consolidate the 25 groups if possible by comparing similarites in the rates. Is there a formula that can help...

Hello, I have a table of data related to an invoice approval workflow where I would like to evaluate each invoice (request key) for the appropriate approver. Unfortunately, the workflow software doesn't store the final approver in a field, so we have to apply logic to the workflow data to...

Hi All :) I have a cell (Y6) that returns a value: IF($K6="","",IF($K6>=61,DATA!$A$91,IF($K6>=51,DATA!$A$90,IF($K6>=1,DATA!$A$89,"")))) I have formatted the results in DATA!$A as I would like it to appear in the working sheet.: <colgroup><col width="682" style="width: 511pt...

Hello everyone, I have a worksheet that is populated with unsorted information. The ranges can be dynamic, with the starting and ending columns being the same, but the starting row and ending rows can change depending on how many items are posted. The items are posted in multiple groups...

Hi guys, I haven’t been on here for a while but I’ve been tasked with creating two graphs from my data set which is really puzzling me. Graph Number 1. I have a selection of Groups with different numbers within them. So A for example contains 5,000, B contains 7,500, C contains 10,000, and...

Hello guys and girls, I have a spreadsheet of 59 columns and 3000 rows that I need to do some sorting. The rows are supposed to be groups of 2 and I need to sort this groups of 2 individually based on the first row. Example not sorted yet, Example sorted from smalletst to largest. I...

I'll make an example. I have three groups: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans...

Hi, I would like help with coming up with a formula which will help me generate 5 two digit number groups.. yes, this is lottery related... lol..... anyway, say I have a number list, which could vary in length, starting in A1 and could go down as many as 40 numbers. the numbers in the list...

Hi Is it possible to expand and collapse individual groups using vba i.e. as opposed to expanding or collapsing all groups. In the following example I would like to have 3 buttons somewhere on the sheet, one for each group, to toggle expand collapse each group one at a time [/IMG]

I run a class that ranks everyone but there is 2 different groups that have to be ranked. There is about 15 sheets and on 1 of those sheets I would like to separate the 2 groups and rank them in order. Here is what I have so far: Because of ties I used this formula...

Hello I'm trying to count age groups between dates such as 01/01/2014 to 31/12/1014. I have the following working for age 16 and under however I have other age groups such as "age 17 to 25" "26 to 30" "13 to 40"not sure how to do this is there anyone who can suggest how I can do this...

I found this: Sub Collapse_All()mp ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 End Sub However, when expanding the groups, they are still expanded. For example, there are 5 groups expanded. They get collapsed with the above code. The 2nd group is expanded & all subgroups...