people

Hi All, After learning that Goal Seek is limited I started to better understand the Solver Tool. Can someone help me with the constraints to achieve my goal? This is my data (paste into A1) <colgroup><col span="2"><col><col span="2"><col><col><col><col><col span="6"></colgroup><tbody>...

I'm just starting to learn about What-If Analysis. At a high level it seems to work for one scenario, but I was wondering if it would be able to calculate multiple what if scenario's a the same time. What way would be able to calculate the CHANGE TO PEOPLE column where it would tell me what the...

I would appreciate any help to create a mechanism to distribute assignments to a group of people. 10 People 22 Assignments (same assignments monthly but not repeated by any one person until has done all 22) 10 instances of each (same) assignment to be done by each person OK that people be...

I apologize for not knowing the right words to use here (and if i knew the words i could look up the answer :-)) I have written a piece of VBA code that does what i need it to and have installed it in the spreadsheet that i was testing it on. So far so good. I now want to give the code to...

Hello all, Merry Christmas! :) I'm new here but feel I'm gonna learn a lot from all you smart people! Hoping you can help me with a little dilemma please... I want to be able to return 4 names in B4, D4, F4 & H4, this detail will be from sheet 2 and will be based on the number entered in B2...

In column A I have ranked people from 1 (best) down to 100 (worst) but they appear randomly. In column B I have names of the people. I need a formula that I can copy down for column C (which re-orders the rank numbers in column A) and column D (that reorders the names accordingly) that puts...

I am very new to using Excel and macro, please be gentle. I have a spreadsheet of people sent a mail out, with each person identified by a unique number. The column headers are unique number, name, address, postcode. I have a second sheet of people who responded, containing only their unique...

Hi there Had a lot of help here before so looking for similar help. I have a big list of accounts with duplicate people for certain accounts Looking to pull specific people that belong to a certain account without duplicates. I have the people in column O with the account number in column F...

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 struggled with this for a week and looked on multiple sites for help. I need to create a chart that has multiple straight lines, each representing a person's beginning and ending score. I created a grid that lists the people in each group (groups are selectable) and I pull the data from a...

I have a data set where the first two columns are cohort and person. This data will build line by line with additional cohorts and new people. I want to make dynamic charts to evaluate the beginning test score against the ending test score. We will be selecting the cohort to look at, and...

Hi Guys! I'd like to understand how to get a result for the below example situation: I have a list of 10 people names linked to 10 different checkboxes. What I want to obtain is that when I check 8 of these checkboxes, the result will contain the names of the 2 people I haven't checked the box...

I have an excel file where in sheet1 column A there are club names and in column B their logos (images). In sheet2 at column A are people names and in column B their favourite club. I want to add in column C the logo of their favourite club dynamically. I know how to do this for a single cell...

Hi there, ive got 4 dimensions to my dataset e.g. below <tbody> <colgroup><col><col><col span="2"><col><col span="3"></colgroup><tbody> Apples Pears Oranges 2017 2018 2017 2018 2017 2018 Manchester % people browse 50% 52% 40% 42% 35% 38% % people purchase 26% 30% 22% 21%...

Hi. I've got a bunch of transactional data that I'm putting into Excel - dates, times, phone and people associated to each line item - kind of like traveling together is the best example I can give. I'm trying to match up the dates and times for Person A to see who Person A has strong...

Hi I'm trying to work out how to calculate productivity for a team based on the number of days worked this month so far. Normally it would be a very straight forward total/av days. However of the two people in the team, one has worked 8 days this month and the other has worked 5. my question...

I have this predicament... I have several excel files with some similar information, but not the same. I get edited copies of these files every week. There is no way that the people sending me these files will ever change how the files are formatted so I have to take all four files and create a...

I designed a tool using vba with few buttons (Get claim, Save, Hold and Clear). Work allocation is at separate file within same shared drive from which claim will come to handlers one by one. (Process first then ll be able to get next one) Managing 100 people on this seems difficult, when...

Looking for the best way to get started with a project. About 50 people in 2 different locations will be adding rows of data to their own basic excel files. The file is unique to each user so there will be about 50 files - updated every 10 minutes of so. Also every 10 minutes or so, I want...

Hello All, I have a sheet I'm using to track schedules. Columns B:C are merged and contain task names, while the other columns to the right have corresponding dates. I do not want people to be able to change the names of the existing tasks in B:C. I do however want them to be able to add rows...