dataset

I am trying to join two datasets (csv format) by using conditional if statements. First dataset is accident information which does have a unique id (caseno) and the second dataset is roadway information which does not have a unique id. To join the accident file to the road file, I have to match...

i have a dataset which can be converted into a graph how do i get an overlapping graph showing the average of the highs and lows 1 17.02 2 16.42 3 16.54 4 16.11 5 17.08 6 17.3 7 17.24 8 -8.86 9 -10.64 10 -8.34 11 -4.56 12 -0.86 13 0.02 14 2.16 15 3.78 16 4.28 17 1.3 18 1.3 19 0.9 20 4.3 21 4.7...

I need to find the maximum value present in column AC against multiple instances of variable X in column D, and populate the value in column F. For example (apologies, I cannot share a true dataset due to the confidential nature of the data): <tbody> Column D ... Column F ... Column AC 1...

Hello, I have two Worksheets; "DataSet" & "SubmitSheet". DataSet: This worksheet contains data in columns A:I (Row 1 contains Headers); I want to copy all data residing in cells "A:D" where adjacent cell "I" is blank (starting on Row 2 because of headers). There will be multiple rows and I...

I have multiple files containing thousands of datasets names and I need to extract the last two characters from the second level of the dataset, below is an example of a files and what I am looking for. file before: A B C Dataset name...

Hi Guys, I have been looking online for a while now and i cant find a way to create a dynamic way of naming a function inside the data model. Let's say I have a Dataset called A and one Dataset called B (Txt files) which have the same layout that i am cleaning and appending through power query...

Hi, I need to compare 2 datasets, both with ~20k records, and determine whether a record in dataset A is present in dataset B. The keys I need to compare need to take into account: - case sensitivity (the keys are only unique when this distinction is made); - wildcards (the keys can contain *...

I am trying to solve problem. I have in my dataset among others also columns named customer and product. Customer can have many products and entries are repeated. I need to have a new column to give number of unique products based on every row of customer column. Dataset is huge and it's needed...

I have a dataset that is grouped by level which I wish to re format onto another worksheet. An example is below: Existing dataset ColA ColB ColC Level 1 Space name1 group1 L1111 Space Level 2 space Name2 group2 C2222 Name3 group3 L3333 Name4 group4 L4444 space Level 3 space...

Morning All, Long time lurker, first time poster. Firstly thanks for all the help over the years, really helped me out. Has anyone used or arguments successfully (Non-VBA route due to audience restrictions)? I have 2 "buckets" A 4 B 6 C 7 D 1 E 3 F 9 I'm trying...

I have this averageif formula, =AVERAGE(AVERAGEIF(F4:F9,{"TRS","TRP","TRX"},G4:G9)) This works well when I have all of the criteria in the dataset, but if the dataset only has "TRS", the averageif returns and error because I think it's trying to locate all of the words inside the formula. How...

Hello all , Ive just had a macro VBA work written for me by a very trustworthy source . My excel worksheet was quote "converted your dataset to a table in order to get the most efficiency out of the calculations". Im extremely happy with my new macros but i have no idea how to change my...

Hi My dataset is similar to below I would like to sum the values in column D, for example, based on a chosen date in cell E1. So if E1 = 22/10/2017 then E2 would = 7 Many thanks <tbody> A B C D 1 06/10/2017 29/10/2017 22/10/2017 2 BA 8 7 4 3 BA2 4 1 1 4 BA3 2 3 2 </tbody>

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

Hi, -I’ve been trying to write a macro that will enable a user to select a time slot (between two dates) and combine this with a specified number of hours to complete a task. My goal is to transpose this information to a dataset and then use this to create an interactive chart. If it would work...

Consider the following example of a dataset: 2,3,3,4,5,7,7,8,9. The average is 5.333. I am looking for a formula that gives me the "next lowest value" and the "next highest value" from the average within the dataset. In this example, the next lowest value is "5" and the next highest value is...

Hi everyone, I'm trying to extract a specific range of values (coordinates X in this case) from a given dataset, using the index match function. The lookup needs to display each coordinate within that range successively. The function works if the and function and one of the conditions is...

Greetings, Thank you in advance for helping if you can. I am using a PC, with excel 2013. I would like to use VLOOKUP with two unique identifiers, or if this should be done using INDEX/MATCH etc. please let me know as I have tried and haven't succeeded. I have played with concatenating and...

Good Afternoon, I’m currently working on a project at work that involves looking at two spreadsheets and adding new information fields like x, y, z to the existing dataset. One is created by myself and the other one is an imported list from an official source. The data is currently only in...

I am new to this forum and therefore, I apologize in advance if I am not posting in the right forum. I am using Microsoft Excel for Mac version 15.28. My dataset has many comments throughout, and also has frozen panes. I have been encountering the following two error message, causing excel to...