doe

Hello everyone, I have a spreadsheet "roles" Column A has user name Columns B:Z have their roles Example John Doe Display Edit Modify I export another spreadsheet from our ERP a list of user and roles but it is only two columns so John Doe Display John Doe Edit John Doe Delete So how do I...

I would like to combine records into a query. For example, the table would be Jane, Doe, teacher, math Jane, Doe, teacher, English I would like the query to have: Jane, Doe, teacher, math English

Ok, trying to figure out how to word this. I have a buy her pay her place and have people that owe me in a spreadsheet. Everyone has different days of the month there payment is due. i want to have the cell highlight the day they are due and highlight a different color when 10 days late. Here...

Hi All I have a huge data file (1000000 rows) that shows amongst other things: Customer Number, Name, Item and Value. Im wanting to reduce the data set by combining multiple rows that are for the same person and the same item. For example in the table below I would like to combine Joe Bloggs...

Hi Guys, Question, imagine a tabel with 100 names on a worksheet in Excel. On another worksheet i want to have suggestions of the data on the other worksheet when i fill in some letters in a cell. So if the name "John Doe" exists in the tabel, and i type "J" in a cell on another worksheet...

I am trying to write a formula that will look at a constant data point (C2) and return all values related to C2. In other words, list all items from a different spreadsheet that refer to John Doe Example: =IFERROR(VLOOKUP($C$2,'sheet1'l$B$2:$C$153,2,FALSE),"") For the first cell, it returns...

I have a very large data set consisting of members yearly work activity. The primary field is the work order number that may have one to many jobs that may be completed in one to many days. What I seek is to group / break the work order in power query then provide the days elapsed, and total...

Hi all! I am not really sure what to call what I am looking for, so if this has been asked before I apologize. I am making a schedule each month and I want to make sure I dont schedule people in more than one department. Is there a function that will allow me to type in a name on one sheet and...

Hi All, I have an excel sheet where i want to work out peoples totals for completed tasks. Example Data <tbody> Date Operator Account 01/12/2018 John Doe Mr Smith 01/12/2018 John Doe Mr Smith 02/12/2018 Jane Doe Mrs Smith 05/12/2018 Jane Doe Mrs Smith </tbody> so from the above...

Hi, I'm trying to use INDEX, MATCH and SMALL to return multiple results and having some difficulty. On Sheet1, I have the following data: <tbody> Study Investigator Study123 Smith, John Study123 Smith, John Study123 Smith, John Study456 Smith, John Study456...

Hi All! I could use some help with this, if anyone has any ideas on how to tackle it I'd be really grateful. Here's an example of what I'm working with: <tbody> ID Location Contact 1 123 Main St 1 Jane Doe 1 Jack Frost 2 456 Second St 2 2 Lacie Lou 2 John Doe 3 789...

I have over 6000 rows of data. I have sorted it so each person has 2 lines of data that need to be added together. Each cust has 2 rows of data that need to be combined, but I need it to return the information in each column Row 1 (Col A - D) = Headers A Cust No B Name C Type D...

Hello World! Here's a quick formula question, I've been using Excel in my mother language, and recently I got a new job where they only use English excel. I've been trying to automate an spreadsheet, pretty simple but every time I try to use SUMIFS it only sum the first value. Here's my...

Hello excel experts, I'm trying to figure out a way to have a countif formula that will capture number of unique dates with multiple criteria. Column D = Names Column E = Description Column F = Date Cell A2 = "John Doe" Cell A3= "Yes" Cell A4 = Formula to return the number of unique days...

I have an issue with COUNTIFS with multiple criteria. Example: Column A has 4 John Doe’s Column B has 4 fruits: Apple, Apple, Strawberry, Watermelon Column C is my Formula: If I just include 1 countifs it works =COUNTIFS($A$2:$A$5,D2,$B$2:$B$5,E2) returns 2 Apples found <tbody> Name Fruit...

I have a excel workbook that is filled out daily that I am attempting to make a dashboard out of. One of the challenges I came across is one of my clients change locations or management a lot. I decided to build a "Settings" sheet to document where that client is, what the building is called...

I have a spreadsheet for work that gets populated with various issues. I have to notify each person who is in charge of resolving the issue, there are so many at this point I am running around all day. Is there a feature in excel or a way to send out an email to a person when their name is...

<colgroup><col><col span="2"><col><col><col span="12"></colgroup><tbody> Name time begin time end weeks------ 1 2 3 4 5 6 7 8 9 10 11 12 John Doe restricted 2/11/18 days-------- 0 0 0 0 0 0 7 7 7 7 7 7 lost time 1/30/18 2/10/18...

I am working on combining test data into one giant workbook. I have two sheets of data. I need to add the mastery values per standard for each student to my master sheet. What formula can I use to accomplish this? Any help much appreciated :) Master Sheet: <tbody> Student Name Student ID...

Hi I want to keep the text "Name:" when the cell is empty. In Format Cells > Costum I write: "Name:" @ This will return my text with Name: in front of it BUT when the value is empty, it returns nothing, not even Name: <tbody> Entered Value Returned value John Doe Name: John Doe...