1. E


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

    Holiday Calendar

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

    Array Formula Help

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

    SUMIF On Column Where Single Column is Primary Key for Numerous Criteria?

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

    Array formula based on 2 criterias

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

    Sumif for category and criteria

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

    Finding Words with in Excel

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

    countifs problem

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

    Vlookup to find data for sparklines

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

    Formula to find all text before a given word

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

    Offset + Dynamic Index / Match

    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\:*...
  12. R

    Show changes (Track Changes or similar) in a new cell

    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?
  13. S

    Multiple criteria lookup including partial text match

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

    When data in cells from two different columns match, take sum of corresponding data from third column

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

    Formula needed

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

    List Values On New Sheet If Criteria Is Met

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

    Creating a formula to model my data

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

    INDEX/VLOOKUP to match and check against another worksheet

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

    INDEX/VLOOKUP to match and check against another worksheet

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

    Countifs problem!

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

Some videos you may like

This Week's Hot Topics