persons

Hi! I have a large dataset consisting of column A and B. In column A there is an ID that represents a voyage. In column B I have names on the persons that were on the different voyages. I want to calculate how many unique persons that were on the different voyages. How do I do that? Below I...

Hello, Is there a way to have a result of the top 5 highest scores? Here's my example. Entered manually: A1 = Dan - B1 = 63 A2 = Bill - B2 = 54 A3 = Steve - B3 = 73 A4 = Ben - B4 = 38 A5 = Patrick - B5 = 45 A6 = Jack - B6 = 104 A7 = Craig - B7 = 73 I put the tie on...

I have a massive spreadsheet of people and their qualifications. Vlookup will only return their first qualification on the list, but I need to know each one by line. I’m trying to use an “IF AND” statement. So, if column 1 contains the persons name and column 2 contains qualification name 1 (at...

We have some file naming conventions where the persons LAST NAME and FIRST INITIAL is enclosed by "--", and then there is the form name then a period and the file application. S:\### xx\xxx\### xxxxx xxxxx--### xx\LAST E\########--LAST E--FORMNAME.pdf I have been trying to figure out how two...

So I use excel a LOT, but am not a formula expert. I am trying to make a sheet find text in various cells across a single sheet and then total the value in the adjacent cell. So it will be searching for a person's name which may appear in multiple places and columns, and then sum the value in...

I need a formula that will be able to count the number of days that a persons name appears in a large data set within a defined date range. The issue I am having is that the persons name will likely have multiple entries on the same day, and i only want to count the first instance. Any help is...

Hi all, I don't speak english very well but I will try to describe my problem. I have a combobox with names of customers on "Sheet1". The name of corresponding contact person and his email will show in C24 and C25 after choosing a customer from combobox. I have list of customer on "Sheet2"...

Is there a way to capture a userid in Access? I have an Access program that is on a network and use so sort of Windows authentication to sign on. I want to capture the person's userid in order to grant certain Access tables in my application.

I am trying to make a chart to figure weight lost gains and losses per person. I need the beginning weight for the month with week 1's weight, week 2 and so on. I also need, in between the weeks, the gain or loss amount which I have figured by subtracting the two. When I get to the end of the...

Good Afternoon, I have a spreadsheet that has all months listed on one sheet for 2018 where I can add up to 4 names in each day as being "on call". Then, I have formulas at the bottom that count the number of times a person's name is listed in the month and then YTD. I'd like to keep all my...

person1 A 66 person2 A 68 person3 A 70 person4 B 88 person5 B 89 person6 A 65 person7 C 90 person8 C 91 I WANT TO GET THE LOWEST SCORE FOR ALL PERSONS WITH AN 'A' NEXT TO THEIR SCORE? THIS IS THE IF/THEN I WROTE, BUT I DONT KNOW HOW TO IGNORE IF FALSE...

Hello everyone! I'm in a new position where I'm allowed to use PQ and PP again. As always, I apologize if I am not asking this using the best terms: I need to create a column within Power Query that indexes according to the column "SiteVisit". The TL (Team Lead) is present in every site visit...

Hello, I have the below text that I would like to extract the person's name (highlighted in bold) who is responsible for "Markup Changes" .. essentially this is the second instance of "responsibility of" Cell text looks like this variable text (Responsibility of: surname, firstname, due...

My workbook has nine sheets, each sheet has project names in column A. persons are responsible for their own assignment, sheet tab shows the person’s name the sheet assigned to. Some project are duplicate, meaning they were assigned to more than one persons. What is the best way to find out the...

Hi all, I am trying to do an equation that marks a person "active" or "inactive" based on the current date, the person's starting date, and the person's end date. Currently, I am using the equation =IF(AND(F$2>=$D3,F$2<=$E3),"<wbr>Active","Inactive") , where F2 is current date, D3 is starting...