Grouping Within IF Statement?

Jan 31, 2013

Create an =IF() statement that divides the infants into four - lb. age groups (beginning at 10 lbs.) and assign a 1 to the lowest group, a 2 to the second, and so on.

10-14
14.1-18
18.1-22

for the three groups

View 1 Replies


ADVERTISEMENT

Utilize A Select Case Statement In Target Intersect Statement

Jul 28, 2009

I am currently using an Intersect statement in a worksheet module to perform two things:
1. Insert a time stamp into row 2 when row 1 has a price inserted
2.To clear that time stamp if the price is deleted at some later date.

My problem is with the time stamp value being deleted by the user.
If I try to clear the price (now that the time cell =empty) I get a Runtime error 91 - Object Variable or With block variable not set.

I would like to convert this code to a select case statement but I'm not sure how to do this in this situation. Would error coding be appropriate in this instance?

View 5 Replies View Related

Grouping Together

Feb 28, 2009

Sheet1 presents my "achievement".

Sheet2 shows what I'm after.

Can this be done WITHOUT any help columns/tables - just by using worksheet formulas?

View 6 Replies View Related

Sum Function In Grouping?

Jun 30, 2014

How do I sum only the total in various groups? I can highlight the cells to get the total but when using the sum function I get the hidden rows too.

View 5 Replies View Related

Grouping The Tabs..

Oct 13, 2008

Is there a way to group tabs? For instance, I have 3 tabs that go with one section and 3 with another and so forth. Is there a way to group them? Also, can you change their color?

View 3 Replies View Related

Grouping Duplicates...

Feb 26, 2009

I have a table in excel that contains many rows, each row being a product. Each row has a product ID, and should be unique, but there are multiple instances of products in the table, some that are duplicate and some that contain different info (product notes, description, etc).

What I would like to do is group the products by product ID, so that I can show the different occurances of the product within each product ID, so that we can weed out the unique values within the duplicate products by ID. Is there any easy way to do that?

excelexample.jpg

View 4 Replies View Related

Grouping In A Graph

Jun 16, 2009

I would like to create a graph where the numbers are grouped in such a way as all numbers between 0 and -1 are shown in one column, all numbers between -1.1 and -2 are shown in the next column, all numbers between -2.1 and 3 are shown in another column etc

The numbers are shown below

11/03/09
-2.5
-3.8
-3.9
-4
-4.1
-4.5
-4.6
-4.9
-5.2
-5.4
-5.4
-5.5.......

View 2 Replies View Related

Sum If And Grouping Dates

Oct 28, 2009

See attached spreadsheet. I would like to take all the departments (column a) and all the dates (column b) and group them. Then add up the sums for columns (e and f) respectively. See desired result in spreadsheet for entire range. How do I do that?
This is in excel 2003. So cant use sumifs.

View 4 Replies View Related

Grouping With Pictures

Mar 18, 2013

I have grouping setup in my excel spread sheet.

1. I added pictures(print screen-->mspaint-->cut existing part of the image-->paste into excel. In excel they are called "Pictures 01 thru Picture X" with the pull points all around.
2. I located them in specific cells of the grouped type with the (-) sign appears so the group of cells are in use
3. When I close the Group(+) of cells all the pictures are jumbled above the closed cells.

Question: Is there away to keep these pictures within those cells when closing the group, so they will not been see as well?

View 1 Replies View Related

SUM Results According To Grouping

Mar 14, 2014

I have a workbook that calculates the total sales per agent but looking a datasheet. At the bottom of the sheet I have 4 team managers who look after a group of agents. I need their totals to me calculated by summing each of the agents in the teams.

I have tried to create groups per team_manager using my team_ref_sheet. On this sheet I have Defined Names / Named Ranges which I thought would work for doing these calculations, but this does not seem to have worked.

View 5 Replies View Related

Grouping And Averaging

Dec 2, 2008

The organisation I wish to report on has many cost centres which each contain many people. These people are on many different grades, and each are on differing salaries (even those in the same grade).

One “reporting group” has many cost centres.

There are several reporting groups.

I need to report on average salary per grade / per reporting group.

I have attached some dummy data. The “rep group” tab displays the reporting groups and the cost centre mappings (ie reporting group England contains cost centres 1, 2, 3, 4, 5, 6 and 7). Note in reality the cost centres are not this simple, they are 6 digits and varying ranges.

In the “salaries” sheet each individual is listed along with their cost centre (in column c) and their grade (column d). Their salary is shown in E.

View 11 Replies View Related

Grouping Like Items Together

Apr 16, 2009

I am working on a set of data and need to group items in the same style together.

Example: ...

View 10 Replies View Related

How To Sort In Grouping

Sep 8, 2013

I want to be able to sort product inventory information. The report generated for me shows on-hand inventory for each product in each warehouse (there are many rows in the spreadsheet per product - i.e. each product/warehouse combination has its own row).

I'd like to sort the table based on most total inventory per product, but maintain the products in their groupings. I know I could do a pivot table and sort it - the problem is, I want to able to see the warehouse distribution for each total. A pivot table would just give me the overall total without the breakdown per warehouse.

Here's an example:

Product #
Warehouse
Inventory

547
100
628

[Code] .......

From this, total inventory for product 547 is 694 units. For product 2091 it's 2,153 units. For product 1165 it's 286 units.
Therefore, I'd like the 2091 grouping to come first (all of it - including the rows showing 0 inventory), followed by the 547 grouping, followed by 1165 grouping.

View 1 Replies View Related

Automated Grouping Using VB

Oct 20, 2008

I have a large excel sheet that will take a lot of time grouping it manually, so I was wondering if there was some way somebody could help me out with creating a code in VB to automate this grouping for me. All I would need is something to read through the rows of one column and when it finds a blank row, keep scanning until the next blank row and then group the data between the two blank rows. I have attached a small portion of the excel sheet I am working with if you need to get a visual of what I am needing.

View 9 Replies View Related

Grouping By Year ...

Feb 17, 2009

Is it possible to grp data in an excel sprdsheet by year or month and also is it possible once that is done to have an option of totaling each period?

On a separate point, but similar:

i have a spreadsheet in one of the columns i have a unique reference eg opal.... at the beggining with some other digits eg opalmimi, or opalniuj.

so i have like 20 or thirty rows (maybe more) of data .

What i would like to do is to sort by the column begining with the opal wildcard and grp and subtotal each wildcard grp

so my sprdsheet looks like this:

Date Desc (where opal values are entered) Amount

View 9 Replies View Related

Grouping The All Dates

Dec 28, 2009

I have my date list in a2:a503 with weekly dates ie. 2/12/2009, 9/12/2009, 16/12/2009 etc etc,
what I would like to do is 1st group all these dates as dec 09 in b2:b503, 2nd point is I would like to have cell c2 to have lowest date (in my example 2/12/2009) and d2 to have the highest (which is 16/12/2009) of that month

ie start date 2/12/2009 end date 16/12/2009.

View 9 Replies View Related

If Statement Within If Statement (recognize The Cell)

Oct 1, 2008

I'm trying to set up an if statement that will recognize that if a cell is FHR it will do something...but if it's PHR it will do something else. I think I found the place where I keep getting an error but I'm not sure how to go about fixing the issue.

View 2 Replies View Related

Excel 2010 :: Use One Set Statement To Set Second Statement?

Feb 14, 2012

I am attempting to use a previously Set variable as part of the next Set statement, pretty unsuccessfully at present.

My purpose is trying to look up

Code:
tb_SelJobID.Value

from a userform in Col Z then look across the row to Cols D,I,N,S & W (different types of work) to see if

Code:
TbSelYr.Value

matches the year selected then insert a formula in the row to the left. Then loop down to the FinalRow.

Currently my Set Found1 statement does not recognise my Found10 value. I know it will be my syntax as it always is. I have cut down the following code to display where the problem areas are, Found1 thru 5.

Code:

Sub CmdGo3_Click()
Dim Row As Range
Dim FinalRow As Long
Dim Found1, Found2, Found3, Found4, Found5, Found10 As Range
Application.ScreenUpdating = False

[code]....

Windows 7 with Excel 2010

View 9 Replies View Related

ADODB SQL Statement ORDER BY Statement

May 5, 2014

I have an Excel Sheet which I use as Database. The database has 11 columns and I insert data with the following function:

Code:
Sub testInsert()
Dim adoCommand As New ADODB.Command
Dim sQuery As String
Dim i As Integer

Dim strTest As String

strTest = "test"

[Code] .......

Now I want to retrieve this data. i.e. I want all F1 where F2 and F3 are 0 AND I want them ordered descending. I'm trying to achieve this with:

Code:
Sub testSelect()
Dim adoCommand As New ADODB.Command
Dim sQuery As String
Dim mrs As New ADODB.Recordset
Dim strTest As String

strTest = "test"

[Code] ....

The result I am getting looks like this:
9
8
7
6
5
4
3
2
15
14
13
12
11
10
1

I assume, that the data is interpreted as String instead of an integer. But I explicitely stated the data as Integer when storing the data into the DB.

View 5 Replies View Related

VBA Grouping Selected Rows

Feb 4, 2005

I have VBA code which selects a group of rows ranging between 1 row and 25 rows. I then want code to group the selected rows, however, the only code I know for grouping requires that I enter a specific starting and ending row (ExecuteExcel4Macro "SHOW.DETAIL(1,#,FALSE,#)").

Is there a way to have VBA group and hide a number or rows which is not known in advance and will change between daily executions of the code?

View 3 Replies View Related

Grouping Some Data In Bar Chart

Jul 29, 2014

I have some cost data for 5 different technologies that I would like to plot in a graph. the technologies belong to 3 unique categories and I want to group them on the chart so that there is no gap between technologies in a same category.

I have a graph where they are grouped by title of the category but how I may remove the gaps between the individual bars in the same category?

View 4 Replies View Related

Grouping By Inconsistant Values

Mar 17, 2008

2 sites are better than one, eh, cos i think this is very tricky. If anyone suggests a solution I'll ensure both sides are kept up to date to ensure nobody wastes their time.

[url]

View 10 Replies View Related

Grouping Dates Into Months?

Feb 27, 2013

I have a table with model numbers as column A, and Row 1 contains dates, each columns contains net sales, my question is there any simple way to group all dates into months and years, i have tried using a pivot and it doesnt work correctly Screenshot (1).png

View 2 Replies View Related

Option Button Grouping

Dec 10, 2013

I'm trying to replace a bunch of checkboxes on a sheet with a bunch of Form Control Option Buttons. The problem I'm having is every option button I add seems to be grouped with all of the rest of my option buttons. If I add buttons 1 & 2, I need those 2 grouped together, and when I add 3 & 4, I need those grouped together. Currently it's grouping all 4 buttons together so 1 - 4 are linked, but I need 1 & 2 linked together, and 3 & 4 linked together. I've tried grouping, but it still doesn't function how it ought to.

View 13 Replies View Related

Grouping And Labeling - All Parameters Must Be Met

Apr 30, 2014

So below is an Sample (Actually about 200 people) of a manually finished product (without names). All parameters must be met.

Basically it will break the Big groups into smaller groups of 4. Assigning the smaller groups a numeric group number starting with 1.

Parameters. No more than 2 members of a club in one small group. No more than 7 lbs between lowest weight member and largest weight member. If it can not complete this, a 3 or 5 (preferably 5) man group can be made.

Sample 3 excel forum.xlsx

View 1 Replies View Related

Grouping Page2 Into Page1

May 17, 2014

Page2 includes collection of things and its properties.

Page1 include only list of things in row-A1 in letter order.page1-row-A1 is our reference row and should BE CONSTANT.

I need to group properties of page2 into page1.

AND what ı need is in PAGE3.grouping2.xlsx

View 8 Replies View Related

Grouping Entries With Same Stems

Apr 6, 2009

First of all, the entries in the following file I refer to are in another language (Japanese, to be exact). I've tried to illustrate my problem using English examples, but they might be a little contrived, so please ignore that :D

I have a list of about 2000 rows/lines of text. Each line/row contains words (which in the grand scheme of things relates to an individual character).

The problem arises that many of these entries share stems and thus take up quite a bit of space. To put this example into English, imagine an entry
larg.e larg.er larg.est gre.at gre.en

If possible, I would like to group these entries such that they come out as
larg.e,er,est gre.at,en

That is, to have a macro or something compare the stems for all the words in a line, and group the ones that have the same stem before the ".".

There are also some instances of prefixes/suffices, which are denoted with a "-". I would like the "-" deleted and then the word treated as a normal entry. Through this some duplicates would arise which would also need to be removed.

So

larg.e larg.er larg.est gre.at gre.en -gre.en super-

Would become

larg.e larg.er larg.est gre.at gre.en gre.en super

Which would end up as

larg.e,er,est gre.at,en super

This is done on a line by line basis - only words in the same line would be compared.

If someone is able to tell me how I might do this, or, even better(! :P), could do it for me themselves, that would be awesome.

View 7 Replies View Related

Grouping Of Rows Dynamically

Oct 21, 2009

I am having a problem with a VBA macro I am trying to write. All I want to do is check all rows in a worksheet and group rows from the last bold row to the next bold row.

I seem to have the conditional logic correct, however, instead of grouping rows separately in each loop, it keeps joining them together.

View 6 Replies View Related

Grouping And Identifying Min Of Each Group

Feb 5, 2010

In Sheet1, If I have Group IDs in Column A and values in Column B as below, is it possible to create a summary in Sheet2 where the MIN value for each group ID is returned?

Sheet 1
A B
1 1
1 4
1 5
2 9
2 3
2 7
3 5
3 2
3 6

Sheet 2
A B
1 1
2 3
3 2

View 12 Replies View Related

Minimum Value In Grouping Of Rows

Apr 26, 2012

I have a grouping and subgrouping of rows in my worksheet and I want to use the minimum value from each group and subgroup and use those values in a report on a separate worksheet using vba. Here's the situation

Emp List (Column)__________________________ Salary
- Workers
__+ Foremen
__- Juniors
____John__________________________________2000
____Max___________________________________1800
____Sandra_________________________________1925
- Management
__+ Seniors
__+ Middle

Lets say Max has the lowest salary among all the workers then I want the report to look like this

Emp Group__________ Emp____________________ Min Salary
Workers____________ Max____________________ 1800

Can I do this using vba without multiple loops at all the group levels?

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved