subset

Hello Guys, I need to create Subsets for the data which I have, which is dynamic, using Excel VBA. I have data in the form of table, whose column headings are Code, % & Transaction ID as the below table. Code % Transaction ID 1001 42.10% 455152 1001 42.10% 455153 1001...

I'm currently working with a dataset which has one dimension(column) with categories a,b,c,d,e, and one dimension(column) with categories 1,2,3,4. I've exported subset 4 and made manual categorization of it, let's call them !,?,#,@. Then i made a pivot table of the subset with categories...

HI I have a series of 5 totals for each year, the slope function over the 5 totals returns 57.6 How do I apply the slope to a subset of the totals The total are 2106, 2008, 2147,2288. slope = 57.6 My subset is 131,158,138,132,547. I want to predict the next number ignoring the first 3...

I have a table and for one of the columns I would like to use a Lookup to populate the fields. The fields should be pulled from another table. Lets say Table A Column 2 should have a drop down box populated with a Lookup from Table Z Column 3. Is it possible that the drop own in Table A only...

I have two groups of items which one is the master set and the second set is the subset. The subset group is missing one or more items from the master group. I need some help in writing a formula to identify the missing items. Column A has all of the items in the list; (A, B, C, CR, CRN, P...

hi all, anyone know this algoithm? i have this problem: have this subset: (5,13,9,12,22,50,18) (A1,B1,C1,D1,E1,F1,G1) and in A2, have this number: 36 How to determine wich elements of the set of numbers sum 36 in this case is: 13+18+5 Thanks

I have a subset of data that I am writing a MACRO to pull out into a different spreadsheet. Within this subset of data I have comparative numerical values in 9 of the 15 columns (E2:M2). I need to be able to highlight or isolate the greatest value in each row, but while also putting this on a...

Greetings, I would like to produce a subset of rows in a population using a loop. Is it possible to add elements to an array variable within a loop structure? Perhaps something like the code below... j = Cells(Rows.Count, "A").End.xlUp.Row For I = j To 2 Step -1 If Cells(I, "A") > 1000...

Hi, I am using excel 2010. When I go to "insert -> symbols" I have the option of "fonts" but I don't have the drop-down to the right called "subset". How can this be added? I think I need this to insert Greek letters like gamma. Thanks

Looking to solve this issue I'm trying to figure out. I need a formula to return the count of suppliers that have "Y" in their respective column. Here is a small subset of data: A1 = Vendor Name B1 = Minority Supplier A2 = Goya B2 = Y A3 = Goya B3 = Y A4 = Monaco...

Hello all, I'm struggling with an Access (2010) issue and if someone could help me I'd really appreciate it as it is driving me nuts! I have a 10000+ record dataset that has multiple records per person. The dataset looks like this: <tbody> Employee_ID Employee_Name Dept_Start_Date...

I am trying to subset some information imported from a json into power bi. I tried the code in RStudio and it worked, but when I imported this code in Power BI, it didn't show any results. I converted the data into a data.frame, but that didn't work. can someone please help me. the code I used...

Hello and Happy New Year!! The target is: I like to have an array with the total costs per year (cost per unit (see table 2) * corresponding volume (see table 1)) for the entered cost positions. Following constraints are given: I like to have the array with the total costs for each year in one...

I'm trying to pull back (based on Customer Number), their #1 Case Reason based on volume of cases, and then when there is a tie (like for 3CTI001-S or 3RTT001), bring back the most recent Case Reason as the winner (from the top tied groups). I'm thinking there are some arrays and countifs...

Hi, I have a dataset with a variable versus depth (see below example). I want to calculate a weighted average of a calculated subset of these data, for example, the weighted average from 3.2 to, say, 8.7. I know how to calculate the weighted average of the full dataset, but not a subset, which...

Hello! This is my first question, I hope someone can help me and I hope I will be clear in explaining myself. So I have two columns , A and B, in each row I have a list of text values separated by ",". What I would like to know is whether all the elements present in B are also present in A...

Greetings, I'm trying to insert two rows in a subset of worksheets in a workbook by defining a range in a worksheet and loop through the worksheets in that range, but the code will only run on the active worksheet. Sub StatePIPData() Dim sheet_name As Range For Each sheet_name In...

I've used Excel off and on for several years, and I'm frustrated that I just can't figure out how to accomplish what seems like a very simple task. Let me explain... I have a single sheet where I register all financial transactions for my business (revenue, expenses, everything). I have a set...

Hi, My team and I are working on researching some of the accounts in our database. Our database contains 15,000 accounts and we're recording our research results into an updatable query containing a subset of about 10,000 of them. I want to add a field to the table and populate it with which...

I am using Excel 2007. I am using a table with headers. I have about 500 rows of data with a column heading called CI (competitive index) - a number from 0.00 to 1.00. I also have a column heading called category. So my table looks something like: <table border="0" cellpadding="0"...