help excel data

Subject: Automate the reorganization of two columns based on the unique identifier "Name", and a corresponding "Reports-to" column. Version: Office 365 OS: Windows 10 Urgency: Low Examples Included So I have a project that I am trying to work on in my free time (but could use some help with) to...

I have a sheet with thousands of rows of data. I have one column with different 'stations'. For example, column D is where my stations are and the data is 1A, 1B, 1C, 2A, 2B, 2C, etc. Each station has approximately 1500 rows/incidents of data that pertains to it. One of the columns...

Hello, I apologize if a similar question was already posted but I couldn't find one. Sample table shown below, the real table is much larger but same general format. I am reading in a given value off a different sheet that corresponds to a labeled name in column A. Based on this, I am trying to...

Good Afternoon, I'm new here and would appreciate any help that can be given. I've got a sheet that is attached here whereby I would like to move the whole row to another tab based on a set criteria. Is there a generic VBA that i can plug my data into in order to make this happen? If...

Hello everyone, I was wondering if you have a quick moment to help me with a formula in excel. We are trying to add a variance filter to our raw data and it would be really helpful to condense this into one formula. We calculate our variance filter: Triplicates with a variability >10 should...

Good Afternoon, After some help with a countif? I need to count number of entries on sheet 2, with two variables; only count if (C+D) < 1 year ago. My raw Data is in two formats so needs substitute for search. Just not sure how to add in extra variables: Sheet1 A B...

I have a file (link below) that i need serious help with. I have employees putting data into a given sheet (T#1)[34 in ttl], then into a given sub form (Street). Now I'm not sure how best to facilitate this but here are the problems that I need help with. 1) eg. make the data (once complete)...

I Have a data sheet called 2017, in the R column there is the months. There is a January sheet i want this sheet to extract all the data from the 2017 sheet if in 2017 sheet column r it says January. here is the file you can check it out im so confused... Click Me

I have this lab report and I can't seem to figure out questions 2 and 3, plus my prof. wants me to make a summary table, which I have no idea what to do. I've attached the questions. But attaching the file of my progress on this format isn't an option. Questions: Data Analysis: To complete...

Hi, I have two lists of data over two excel sheets within a workbook. ('sheet 1' & 'Matured') What I would like to do is input some form of formatting that will highlight any cell on 'sheet one' that contains a value that is on the 'Matured' sheet. 'Sheet 1's data is in cells U2 to U2474...

Hi, I am trying to create a tracking spreadsheet and i need help coding my submit command button. I know how to submit data into a generic spreadsheet but my problem is i want it to submit into a table i have created. What i am looking for is: When selecting the address in the user form, the...

Hi, Need your help with the below sample of data, I am in a great mess, as my employees are fooling me, My employee, who I have appointed to do all the data work, is saying this is not possible to do. Please help me with it, I am running in huge losses. Summary.: Data is Entry and exit time...

Hi all :smile: In need of help! I have a spreadsheet containing dates in columns (12/09/16 in cell A1, 19/09/16 in cell A2 etc). Underneath each date (which is effectively the column header) I have ten rows of numbers. I need to be able to type a date into a cell on another sheet and have a...

I'm currently running excel 2010 on windows 8.1. I have a set of data from a txt file open in excel. I then plug that data into an equation I'm using to get my desired outcome. I then want to save only the data resulting from my equation as a tab delimited txt file. However, initially saving...

I have to go through 14000 rows of data and validate them with another sheet but the problem is I have to change the original to match the other sheet but there are rows in one sheet that aren't in another I have to put on another tab and vice versa. Any ideas besides going through them one by...