chris

Hello, I'm trying to use a sumproduct formula to pull in data from a table with 3 criteria, but I need one criteria to reference a table. Here's an example of what I'm trying to do. I'm trying to pull how many apples Chris sold in each state. Sheet 1 <colgroup><col...

I am trying to create a holiday calendar for my office that when the holiday is booked in the table (list) it highlights the days taken in the below calanders. I was pretty sure I could do this by index match until that didnt work that is, so now I am stuck. Has anyone got an idea of how I can...

Hi I am trying to help my son with his assignment and he has been told to get his sheet to show blank in this array formula returns a value of #N/A {=VLOOKUP("N4",CHOOSE({1,2},Table1[[#All],[Seat Number]],Table1[[#All],[Ticket Number]]),2,FALSE)} I have tried using If(ISNA) in the array and I...

I couldn't come up with a clear title. Here's the question with a proper example. Two Tables of Data: TABLE A <tbody> Name GP M P A R James 80 3040 2320 880 480 Steph 72 2448 1800 576 288 Kevin 73 2555 1971 511 511 Chris 78 2730 1404 780 234 Patrick 80 3200 1760 160 960 </tbody>...

Hi All I know this will be pretty straight forward, but i'm struggling to ask the web the right question.. I have an array formula that brings back an "order number" in column E, based on the order date in column A...

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...

I have a sheet with a list of name example Aaron Tumbler, chris Turner etc Have got another sheet in which the names are mentioned as Tumbler Aaron, Turner Chris... Need help to check whether name mentioned in sheet 2 is there in sheet 1 Thanks for your help

<colgroup><col><col><col></colgroup><tbody> Name last visit more booked John 01/01/2019 1 John 16/01/2019 John 01/07/2018 1 Chris 01/07/2018 Chris 01/08/2018 1 Chris 01/01/2019 </tbody> looking for formula to count if active person within 30 days or if more that 30 days but...

<tbody> sheet 1 Sheet 2 Name Sparkline Here Name J F M A M J Bob Jim 7 8 3 1 6 2 Chris Nick 3 9 6 2 0 5 Jim Bob 5 6 8 2 3 5 Seth Seth 2 0 6 8 2 7 Nick Chris 3 7 9 5 6 8 </tbody> I have a list of names on Sheet 1...

Hi Everyone, I need help in excel. Please find below for example: <tbody> A B C D 1 Vikas Agarwal John Monty 2 Parul sharma Brown Peter Chris 3 4 </tbody> i want to take all words mentioned before John/Peter. so my B1 should be Vikas Agarwal and B2 should be Parul...

Hi, Ive been working on a a dynamic INDEX / MATCH, which I've sovled. How ever the values I'm returning on not always unique, and I want to lookup other values from the same column/row. <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:*...

A1 - original sentence B1 - edited sentence C1 - is there a way to show what has changed similar to track changes in this cell? A1 - My name is Chris B1 - My name is Dave C1 - My name is ChrisDave The word Chris would have a strike throguh it?

Hello, I'm trying to match cases from my lookup list to my master list below using multiple criteria, to get the output in column H. I am able to match the "Chris Dobbs" case in row 4 by concatenating last name and gender on each of the two lists. But i cant figure out how I would find...

Hello, I have been having some trouble figuring out a SUMSIF or SUMPRODUCT formula to accomplish this, as well as searching on google and the forums for some time. Can someone please help me with the formula to accomplish the following: Three columns of data, A, B, C: <tbody> Chris Chris...

I run a report that I export into excel and it will have multiple names in one column separated by a comma. How can I move the crew members into their own column? <colgroup><col><col span="3"></colgroup><tbody> Current COLUMN A...

I have data set up in the format below. You will see that there are duplicate values in column B and some duplicate values in column C. Is there a way to list the parent value (column B) when all child values (column C) related to that parent says “Chris”? I’d like the list to be on...

Hello, I am having some difficulty modeling data with two independent variables and a dependent variable. The data is included below: <colgroup><col><col span="2"><col span="3"></colgroup><tbody> 20000 40000 60000 80000 100000 2017 12375 11000 9475 9250 9250 2016 12100 10800 9450 8150...

I'm a bit of an Excel noob so bear with me here. I have the following abridged sheet: Sheet1 H AP AO 1 Transaction Description Employee Name Type 2 ER 12345678 blank...

I'm a bit of an Excel noob so bear with me here. I have the following abridged sheet: Sheet1 H AP AO 1 Transaction Description Employee Name Type 2 ER 12345678 blank blank 3 ER 13182984...

This is doing my head in... & I know this is going to be a missing bracket or comma or something... :confused::confused: data = <tbody> A B C 1 01/01/17 chris 01/01/17 2 06/01/17 geoff 08/01/17 3 12/01/17 bob 15/01/17 4 12/02/17 chris 22/01/17...