people

Hi, I have a large workbook tracking the attendance of various employees. I need to count how many people have certain events, ie how many people were late in a month or how many people are ill. I am getting an error whenever I use the following type of countifs, it has something to do with...

Hi - another query for people more Excel savvy than me...... I am trying to make a cumulative total of people attendance from different spreadsheets onto a master template but discounting the term "#N/A" So, I am trying to total the numbers from cells C15:AH15 <tbody> B C D E F G H I...

Hi guys Any way to prevent "Personal views" on Excel? My workteam have 15 people working on several Shared Workbooks and all users have Office Professional Plus 2016 on W10.. I have defined that all files have the freeze pane at "C2", but there are some people that insists on unfreeze...

Hi I really need some help with this. Sorry I can’t post the excel file here as it has private information. What I am trying to do is get all of the names of people that spend over 1,000/ month that work for a specific company. The names are in column a that need to be returned. The amount...

I am trying to create a formula that will pull in some information from one spreadsheet to another. The current spreadsheet shows lots of names and test results. For the new spreadsheet, I only want to pull in the names (and some additional details on other columns) of the people that have...

Hello All, I've just released a very large project for my office and my first tester is the only person I can find in 6 different people that can't type or even select the only combobox in the workbook. The office is mixed running 2013 and 2016, I've found people can use this box regardless...

I want to submit a plea to activate the vBulletin attachment feature. I have used it on other forums and it works very well. I can upload an image from anywhere on my hard drive, with some limitations, and attach it to a post in several ways. I have reviewed the threads discussing the...

Dear All, I need to find out which people are in list A but not in list B. How could I do this? I guess I need to use IF function, but I am not very familiar with this and would appreciate someone's help. List A is in cells A 1:328 List B is in cells B 1:438 I expected to have two the same...

Hi I have a spreed sheet that has names and address on it. A1 has a name A2 has a number and a street A3 has a city, state, and zip code (which is a number) A4 is empty A5 is empty A6 has a name A7 has a number and a street A8 has a city, state, and zip code (which is a...

Hello, I have a list of people who took an action and the date onwhich the action was performed. Some people have the same date listed formultiple actions, others have more than one date for multiple actions. I need toidentify (maybe in a new column so it can be sorted/counted in a pivot...

I'm trying to set up a spreadsheet that calculates peoplesworking hours but I'm getting into a pickle and keep getting the error #######,when trying to work out if people are over or under their expected workinghours. I have effectively 3 columns, the first shows the number ofhours people are...

Hi all, Ive used this forum for a while and it has always answered my queries by reading, this is my first post as I cant seem to find the answer. Any help would be greatly appreciated. I have a database of people with dates along side. I would like a live list that populates a cell based on...

Hi, I've been searching for a while now how to solve my problem, but I can't find a solution. I have a shared document, altered by several people at the same time. When someone changes cell B2, I want their windowsusername displayed in cell C2. I already made the function =Username() in VBA...

I'm quite rusty with excel so could use some help. I've created a staff rota spreadsheet which tells people which department they'll be working in that day, and have a separate sheet that counts up this information to tell the management team how many people will be in any given department per...

Hi Everyone, I have a document that we use as an input document. All people have to do is Type in the amounts etc into the correct cells. everything is protected and setup nicely so you would think this is fine, but NO. Some people insist on breaking it! the latest way is with cutting and...

Hopefully this makes sense, it doesn't sound possible to me. I have a number of columns E through to JG. Every 2nd column has a number (of people required) in rows 11 through to 72, some are blank on purpose. Every other column number is a price for that number of people. The number of people...

Hi If you write an excel application that will be distributed to a high number of people. You dont know what excel version they use etc. How do you go to be sure the application will work for the highest possible number of people?

we are trying to alleviate some projects and trainings and hoping to streamline how we select people for different tasks. In a week, 10 people will be selected at random but depending on the week, the list (which in excel which is a table due to the changing number of names) to choose from could...