matt

<tbody> A B C D E F G H I Result 1 Matt Tim Joyce x x x x x x Dup 2 Kyle Joyce Tim x x x x x x Unique 3 Joyce Matt Tim x x x x x x Dup </tbody> Hello, I have 9 columns A:I, and have around 2 rows 1 - 21. In each of these cells there I a name...

Not sure how to combine this into one formula. =IF(ISNUMBER(SEARCH("m",Invoices!C2)),"DC","DS") =IF(ISNUMBER(SEARCH("c",Invoices!C2)),"DC","DS") Thanks, Matt

Hi Experts, I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help. Here is the problem. I have 2 sheets. SheetA and SheetB in the same workbook. SheetA...

Hi there, I am looking to create a sumif (or sumifs) for the following data set, so that a sum is given for each name, HOWEVER with the caveat of the addioanl criteria of under a certain value. For example, the total sum of volume for Matt, but only for values less than 4. Please can someone...

Please Help.. I am trying to get a formula that will return the wt. per lf of size of bar in F3 from the table B30:J41 and will also return the length of lap required in F5 from the table B30:J41. I have tried several different formula's but nothing has worked. I have even tried breaking it down...

All, I am attempting to extract a series (5000 cells) of data based on 3 criteria: Name, Date and either Time or Fz. Becuase for each set of actual Data (Time and Fz), there is a name and a date of the same person associated Here is the index match array formula I am currently using but it...

Hi Everyone, I'm having a hard time getting a loop to work. Basically I need to iterate over the entire population of students in column A and start a loop when a cell says "TestLoop". Within the TestLoop, I want to count the number of times "In" or "Out" occurs and exit after 3 "Outs"...

A B C D E 1 $100 Yes Matt 5/10/18 2 $200 1/10/18 Jim 5/10/18 Sum A, IF B = Yes C= is blank If B is "yes" and C is blank/ empty, then D= Matt E= Month, May (Month=5) In this instance, the answer would be $100...

Hi Everyone! I'm working on a spreadsheet where everyone's work hours are tied to the project he or she is working on. For example, I have the name of the person in Column D, and Column R is the hours billed to the job. The hours billed to the job comes from a list at the bottom of the...

Hey Mr EXCEL users, I need some help about this please: How can I sort the names column in each sheet. For example: we have some names like this: Sheet 1 (Main) <tbody> Name Birthday Class Kofi 02.09.2011 B Matt 18.10.2011 C Kathrine 15.07.2011 C </tbody> Sheet 2, 3 and 4 (October)...

I'm trying to write a macro that will do the following. Take a list of names and data and assign them to other people broken by header. For example from the following list: Christine gets all the data associated with Mark and Matt. Dolores gets all the data associated with Barb and Mike. Janet...