data array

Hi, If anyone can give me a kickstart with this it will be appreciated. In the linked excel file there are 2 tabs. I want to work with the first tab, GM SOR's. The first row has identifiers or column headers. The first column, Sub Trade has a number of trades listed multiple times. Each...

Hi, I have a few hundred cells which all have 4 digits in them seperated by a space. Eg Cell A1 has 4 16 23 43 in it. Cell A2 has 5 78 76 45 in it. What I want to do is have formulas in Columns B,C and D which extracts each number out So cell B1 would have 4 C1 would have 16 and so on. I...

Hi All, I have a question on what you think would be the best way to solve a problem that I have... I have attrition numbers for 12 months in columns and City_Tenure in the Rows, it looks something like this.... <colgroup><col><col><col><col></colgroup><tbody> Code ATTRITION_Jan_18...

So currently I have an advanced filter that triggers on value input. However when I try to make criteria cell formula based it ignores changes. unless I click on cell and hit enter Here is my advanced filter Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target...

Hi all, I'm working on a spreadsheet that requires me to look up payment schedules based on a property's geocode between two sheets. The tricky part, however, is that I must match three different types of payment (tax, operating expenses, and rent) for each geo code. To make things more...

Good Day, I'm trying to figure out how to pull data from my raw data page (Screenshot 1) and transfer certain data to the second spreadsheet (Screenshot 2). I'm having troubles with getting my formula to populate the correct run number. I'm trying to use Index match function. If I select...

I have searched the forum for a suitable technique to solve this problem and I can find nothing that helps. I have a spreadsheet that tracks a large number of staff and changes to staff status. worksheet 1 contains the core data and tracks changes on a week-by-week basis (each week starting...

Hello, I am creating a template that starts with a time series of daily values for the past year (the specific dates will depend on what day I am updating it for). I need to be able to manipulate monthly data from the time series. I am running into issues because there are gaps in the data...

Hi - I have three acquisitions which will occur in different months (i.e. one in Feb; one in Apr etc): <colgroup><col><col span="6"></colgroup><tbody> Timing of Acquisitions Jan Feb Mar Apr May Jun Acq1 1 Acq2 1 Acq3 1 </tbody> When acquired, each acquisition...

I have an array of projects that we track by phases, and I am trying to figure out how (if possible) that I can pull specific data points from that data array. I've created a mock up below picture 1 is what I am working with and the second picture is the data that I would like to pull from the...

Hi, I have a report that i download from an internal system (weekly). It lists all employees and details their compensation. However, it lists each compensation element in a seperate row - example below. I need to be able to covert this so that one employee only takes up one row and the...

Hey Guys, Thank you for reading my question(plea for help), I really appreciate your help (I'm on my knees, begging) I am making a bowling league excel sheet, I will have 10 - 15 teams. Each team will start of with a rating. - There may be no games on a particular day, or more than 1...

Hi - I'm having trouble identifying a formula that will reference the first column "Hours" and populate a closed/open status & corresponding time per day of the week in a corresponding cell. Does anyone have suggestions on something that might work? <tbody> <tbody> Hours Sunday Open Status...

Hello, I have some data for some sales information that I am trying to organize in a different manner. I have around 5000+ row of data formatted like so: <colgroup><col span="2"><col span="2"><col span="11"></colgroup><tbody> Item # Whse Item # whse # Month 1 Month 2 Month 3 Month 4 Month 5...

So I've been looking around and haven't quite found the formula that I am looking for. What I would like to learn how to do is:take a cell and look for that number on another sheet and post the unit price and product description accordingly on the first sheet.

Backstory: So I was assigned a project that requires me to graph (chart) values (y-axis) against time (x-axis). For each row there is a "budget", "spent", and "earned" value (easy enough so far). I put together a pretty slick "running total in" pivot chart that was slice-able by any number of...

Hello all First time poster and I am hoping for some kind help today. I have a large set of data that I would like to organize quickly. Currently, the data is set in two columns. Column A contains parent names (almost 5800) and column B contains child information. The child information can...

Greetings Excel Guru's, <tbody> Clients C B R A Car Bus Rail Air John Public X John Public Jane Doe X X Jane Doe Jane Doe Mary Smith X Mary Smith John Doe X X John Doe John Doe </tbody> Clients list is the master list of all names. From that list, I...

Hi All, I have a worksheet which has 4 columns. The first column contains name of person, The second column contains project code(the same code repeats for other persons as well), The third column has target values(This also repeats), The fourth column has total hours spent on that day. I...

I have a very large data table which i want to sort out by amounts into a top 5 table by type and and name. I need it so any person, amount or fruit can appear in the table multiple times by the highest amount as the search criteria. Here is an example of the table i have with my data...