data analysis

Hi, Im facing new challenges in my office, like restructurations from all sides. There's an oportunity to get a specific Data Analysis Team and set new ways to play with data. That Team regularly uses Excel to deliver Statistical studies for all the organization. I'd like to know if there is...

Hi guys, New to excel macros, but having seen a couple of vids on You Tube I'm quickly becoming fascinated by its potential! So anyway, there's a task a run every morning and I think a macro could help but i'm hitting huddles. Wonder if anyone can help? The task 1 - Take 2 csv downloads...

Hi, I am a little foxed. I have a cell entry 08/10 Two numbers separated by a forward slash as text. The idea is that is a number is less than 10 its filled red if not green if there is an entry I was hoping that the following screen shot would do the trick, but alas somethings not quite...

Hi, I have acquired two set of datasets with Time versus Data; T1 vs D1 and T2 vs D2 T1,T2 is timestamps in hh:mm:ss.00 and D1,D2 is data in Numbers format. T1 and T2 intervals are different, while the T1 has ~1second interval, T2 has ~100 millisecond interval. However the overall time period...

Hey, I'm a beginner at excel but I was tasked with refurbishing our budget template. It's a construction company and in the budget we describe what we're doing and what materials we use and price it by units, square meters etc.. The thing is we use a lot of materials, and looking them up by...

<tbody> Small Medium Large Blue 1 1 2 Red 1 Green 2 Orange 1 Purple 1 2 Yellow 2 1 1 </tbody> I have a worksheet that I need some help with. I need formulas to accomplish a count. Basically I have two columns outside of this range. One column is...

I have tried =$A1<>$B1 but this only looks at two cells at a time. =$A1:A5<>$B1:B5 does not work. Ideally I would like Excel to check for differences between two tables row by row and highlight them. If not then at least return True/False for a range. I have a lot of data to sift through! I...

Please help I have a spreadsheet that manages queries on a daily basis, each entry is time managed by a userform (ie timer starts when form opened and stops when closed) the start, stop and elapsed time get input on the log. This log is used by several people daily. the formula i have at the...

Hello all! I am working on a project that tracked participants eyes as they looked at various pictures. I now have several tables (for each of the different participants) and need a way to determine a trend. The tables currently have, where they looked (Location 1, 2, 3, 4, ext.) and how long...

Hi, I am creating a summary of temperatures logged every hour for three years at several different locations. I am summarizing by the hour (row headings) and location (column headings). The problem is, some locations only logged temperatures every two hours, while some logged every hour. When I...

Hi all, Wondering if anyone could help. I have a column of data with values ranging from 0- 30+ I would like to know the number of values between 5-10, 10.1-15, 15.1-20, 20.1-25, 25.1-30, >30 is the are 'countif' statement or something i can produce to find this? It would be incredibly...

Hi All, I have a large data set in sheet1 which has ~20 columns and 10000+rows and each row has a set of limits based on what value is in column B this data set changes ~once per week. The limits are stored in sheet2 where column A contains the unique list of values from column B in sheet1 and...

Hi, I ran the data analysis program for a t.test on some old data. I want to update the selection to include new data entries, but cant find out how to edit my selection. Is this possible or do I need to just start over? Thanks, Sam

Example data below to explain a little further- Basically what I need to do is figure out a macro or a formula column which will calculate out the possible outcomes based on the data set that will find the consolidated versions possible. Maximum weight for this example is 20,000 Maximum...

Hey guys! I have a very important and urgent question: I am doing a quantitive content analysis of newspaper articles and have coded them all in different categories. One of the categories would be "Gender of the victim". 1=female, 2=male, 3=both, 4=not specified, 5=not applicable. In one of...

Hello everyone, I would like to create a bulls-eye type graph, but instead of a single line I want to make bands, or regions (zones) that would highlight areas such as 10% to 20% is green, 20% to 35% is yellow, and +50% is red. I was previously asked asked to create a few bulls-eye graphs for...

My problem is that each employee appears in the table for each month and I need to gather the data for each employee in a single line. <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Last Name First Name Location Employment Date Termination Date 1-Mar-2016...

Hello. First of all: thank you for all the times this website has provided me with answers through threads posted and answered by people who have been here longer than me. I'm sure that if I wasn't so clueless this time, I would have found a solution on the forum already. So this is the...

Good day people. Thank you for your support so far... I need to merge some data values from some spreadsheets to another.. Table A for Year 2013 <tbody> Family ID City State Postal Code Amount </tbody> Table B for Year 2014 <tbody> Family ID City State Postal Code Amount...

Hello all, I may have jumped to conclusion. One final piece of the query. The code provided by JLGWhiz works perfectly fine but I needed to ask my question with even more specificity. And again, thanks for the reply, JLGWhiz. __CODE__ Sub t() Dim sh As Worksheet, i As Long Set sh =...