people

I have a list of names in a column.... then I have 6 columns with different disciplines..... people take part in a certain number of disciplines, I want to be able to make a combo box that will include all people that are participating in one discipline (1 column) and place their last name in...

Hi guys... If i have 200 applications to process daily and i have 12-15 people to process them daily, each application takes about 3 hours. How would I put this piece into an excel formula where I want 3 hours to be average to process each app or ok.. how many people would i need in order to...

I am having issues with a filter automatically updating. I have a set range of cells where a sales league table updates. i have 198 positions in the league table incase of increases to staff. i then have a little formula to the right of this that i will hide. i was hoping it would be a case of...

Hello, I would like to format cells based on the value in another cell. Eg, column A has names of staff. column B gives the score from an assessment. I would like the name (column A) to change to red if the score in column B is 1. I'd like the name to change to orange if the score in column...

I would like my spreadsheet to have two sheets. One will have people with their areas of interest and expertise. The second sheet will have requests from customers for people with specific areas of interest and expertise. Can I make the second sheet search the first one and come up with people...

Is there a way in a new column to group people in groups of 9? The first 9 people would be in group 1, next 9 people would be in group 2, etc? <tbody> Person 1 1 Person 2 1 Person 3 1 Person 4 1 Person 5 1 Person 6 1 Person 7 1 Person 8 1 Person 9 1 Person 10 2...

Hello, My name is Byron and I have been given a task and I am having some trouble. I have just joined up today to ask for some help. I have had a go at searching for different posts but cant seem to find what I am looking for, so I hope what I want to achieve is even possible. I have a...

Hi i am trying to setup a hyperlink formula for a file directory, normally as many people will be using this spreadsheet typically they will have saved the directory folder under different letter eg A:, C...

I have a very simple basic excel sheet where we store data. I have about six people that enter data and about 30 people that open the sheet just to get data. The problem is, the sheet is always open by someone and the 6 people can never enter data because it opens as read only. What's my best...

Hello, Apologies if this has been asked before, I may not be using the best key words to search for. I have a form which has been filled out by people and the form responses are outputted to an excel file. I want to search this file for the entries made by specific people and at first thought...

Hello, Is the below example possible? I've been able to determine how many people live within a certain distance (in miles), thanks to this board (thank you!), but now I'm looking to determine how many people live "within a 30 minute drive", using lat. long. coordinates as the reference points...

Hi, I am currently working on a template to be shared among several people within the organization. It is suppose to be stored in a sharepoint using the web. The idea was to generate a backlog where you could see all changes that people have been doing. The purpose for tracking the changes is...

Hey guys, I think I need to work backwards on my on-going issues. Let's say I want to create a 24/7 loop. I have a on-time WAIT application of 10 seconds - basically restarting the below. I want to find "1" in A1 on sheet 1 and then I want to grab B1:B5 and paste on Sheet2. A1 will turn...

Hi I'm sure this is simpler than I'm finding. I have four columns of data which the number of rows vary from week to week. The data set is normally multiple days. Date | Name | Start | End The thing... I want to allocate each person a desk however I want it to check the end time of people...

Hi, I have (410 line) data like the sample attached below. Need VBA code to create a shale chart. With Unit being the various areas and End by being the X-axis. Logic: All units put together totally there are 410 people. With 17 people having end by P1, 410 will get reduced by 17 in P02. this...

Hello...My name is Devin, and I am planning to host a dinner among friends and acquaintances at a large dining hall within the next two weeks. I am playing around with a formula that will allow me to seat people who I think MIGHT be a good match for conversations(maybe); people who I think WILL...

I hope this is the write place for this. If not my apologies. How do you post a table in the forums (excel, Access...) I see where some people show a table with sample data to help explain their questions. Where/how do I learn how to do that?

Hello Everyone, First time poster and hoping you clever people can help me with a formula that seems beyond me. My formula is as follows: =IF(A2<"","In Progress",IF(A2="","Dormant",IF(F2="","Complete"))) So if A2 is empty it is "Dormant", if it contains anything it is "In Progress", but it...

I have (inherited) a spreadsheet where about 5 people enter data and about 20 other people view the data. My problem is the 5 people can never enter data because someone else always has it open. Any suggestions as to a what would work in this situation? How can I have a spreadsheet where if...

Hey All, I've looked through google and remembered I've been helped before here, so I figured I'd ask. This is probably simple for most, but for me, nope. I'm looking to use Excel to keep a track of people I play games with, say I've got a game with 4 players maximum, and 12 players, I want...