person

I have scores for 4 different people in range C4:Q37,Z4:AL37,AW4:BK37 and BT4:CH37. These scores will either be NA, 0, 1 or 2. If it is a number, I need to find an overall percentage. Each persons score per item is on one line, so for person 1, C4 :Q4 will have a value of NA, 0 , 1 or 2. (There...

Hello there, I want to use the COUNTIFS with a dynamic columns. Assuming the below is the data set in Sheet1. <tbody> Test 1 Test 2 Test 3 Test 4 Test 5 Person 1 6 2 1 2 4 Person 2 0 1 3 0 7 Person 3 4 2 3 3 3 Person 4 4 3 4 3 4 Person 5 4 3 4 2 5 Person 6 4 2 4 3 4 Person 7 5...

Hi, I am trying to summarize my data based on rank and position with its corresponding wage. I'm trying to do it on pivot but cannot produce my desired result. Thank you in advance! Below is my data <colgroup><col span="2"><col><col></colgroup><tbody> DATA RANK POSITION EMPLOYEE WAGE...

Hello, I am trying to count unique text in a column based on duplicates in another column. For example, I have this <tbody> A person x 2 A person y 2 B person x 1 B person x 1 </tbody> So in the above table column one shows the duplicates . I am counting the Unique texts in column 2...

I am working on a spreadsheet and I want to round the year for Voluntary Life Product. Basically, I want to take the birthdate and round it to a specific date so that the person doesn't age up until that specific date. For example. If the person is 59 a will turn 60 on their DOB of 5.9.19, but...

I have some cells in a spreadsheet with a small red triangel in the upper right-hand corner; don't know how they got there. If I hover ove the cell I get a message box with the name of the ONLY other person (besides myself) that is allowed to modify data. How do I ger rid of this red thing...

I'd like my end users to be able to type a text note and store it in an excel sheet. The note would be edited by the next shift, and then saved to the spreadsheet. There's no requirement to save it other than the next person would be able to see the concerns of the prior person. Very simple...

Hello I am a software tester and I will soon be carrying out end to end testing which will cover a period of 6 years. Without the luxury of software tools I will utilise Excel. Currently my plan is to make every column a day (2192 columns), and every row a person (up to 500 people). Every...

Hi Every One, i required the Output which is highlighted in Green <colgroup><col><col><col><col span="3"><col><col></colgroup><tbody> Project Name Week1 Week2 Week3 Week4 Person Name P1 P2 2 5 S P3 6 R P4 P5 8 R P6 P7...

I dont know what ive done wrong to my index match statement. I need to get monthly earning into a column. each person has 12 months in a row. On a separate spreadsheet I have the dollar amounts per month for each person. I need an index match statement that will put the 9.50% in the column...

I would like to send an email for each person in a table based on the confirmation column. Meaning if is True, that person will receive the email. Otherwise not. I would like also to choose to send to everyone (Confirmed as True) or to send individually. <tbody> Name Email Type Confirm John...

Tis the season for Christmas gift shopping and I'm trying to do a worksheet where I can do a lookup for items spent per person. It works fine when there is something listed for every person but, if nothing has been spent yet for a person, it returns "N/A." Is there someway I can alter the...

Hi all, I got this setup but can't figure out how to get the total amount of time from column C to column D. <colgroup><col><col><col><col></colgroup><tbody> Row Labels Count of Shipment Min of Tid Max of Tid Person A Trp2 1 10:48:00 10:48:00 Trp3 4 12:29:00 16:52:00 Trp4 7...

Hello, Apologies if this is repeated, I've tried searching for an answer but have not found anything. I am looking for a way to calculate a percentage based on the number of cells with a value example <tbody> Sales person 1 Sales person 2 Sales person 3 Sales person 1 % Sales person 2 %...

Guys, Is there a way to adapt the code below. It currently does the following but I would like to adapt to do as per the below steps. The final data will be a table not a range. Not sure if that makes a difference Currently the code does the following ( code below) filters by New call in...

Hi I have a team whose work is split alphabetically, each person has their own alpha split and associated workbook. I need to be able to restrict their input to only names within their split anything else should produce an error. eg 1 person has an alpha split for M - Mi. I have tried a few...

Hi - I've been madly googling this problem and cannot find anything that quite solves it for me. Looking to this forum which has helped me so many times before (although first time posting a question!). I have data capturing number of hours and pay rate, by person, each day. What I want to do...

Hi, I have two questions for my project below. I have a table TblSales in B:G and I try to do the equivalent of the pivot in L5:P10 by storing and calculating values in an Array (I put it in L13 to show result) [/URL][/IMG] The result is very close but as you can see the People are not sort...

Hi all. A small problem I just can't seem to wrap my head around... I am trying to create a planner and I've tried countif, Datavalidation and conditional formating but when ever I think I am close no dice. My challenge is this: I have X number of people who all have to have lunch together...

I am trying to use the same priciple behind sumproduct since I have a lot of moving variables in my table and reference that need to be matched. I have the sum products working fine (see example) because they are actually finding sums. I need to do an average of the CM/ST and CM/MT since there...