Search:

Type: Posts; User: AhoyNC; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.22 seconds.

  1. Re: IF statement to check for value in range and if true include adjacent value in SUM

    See if this works for you.
    Copy formula down and across.

    <b>List and Totals</b><br /><br /><table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  2. Replies
    3
    Views
    144

    Re: Reverse VLOOKUP? INDEX - MATCH?

    You're welcome. Thanks for the feedback and welcome to the forum.
  3. Replies
    3
    Views
    144

    Re: Reverse VLOOKUP? INDEX - MATCH?

    Maybe something like this. Copy formulas down as needed.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff;...
  4. Replies
    3
    Views
    101

    Re: working with times and dates

    Something like this?

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; ">...
  5. Replies
    1
    Views
    74

    Re: sum ifs + index match

    Here is one way with SUMPRODUCT. Copy formula down and across as needed.
    You may also want to look at a pivot table.

    <table border="0" cellspacing="0" cellpadding="0"...
  6. Replies
    6
    Views
    179

    Re: Index and match with large function

    You're welcome. Thanks for the feedback.
  7. Replies
    6
    Views
    179

    Re: Index and match with large function

    See if this works for you.


    <colgroup><col style="width:30px; "><col style="width:133px;"><col style="width:107px;"><col style="width:64px;"><col style="width:64px;"><col...
  8. Replies
    4
    Views
    91

    Re: SUMIF - dates, ignore times?

    Maybe another option to use SUMPRODUCT:

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; ...
  9. Re: Why this Match is not working, FILE ATTACHED

    Another option if you have Excel 2010 or later:
    This does not require CSE just ENTER.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt;...
  10. Replies
    3
    Views
    157

    Re: Max If formula - where am I going wrong

    Probably need to clarify what you mean by gone wrong.
    Are you getting an error msg., wrong answer?
  11. Replies
    2
    Views
    153

    Re: Average Array Formula Help

    Try:

    =IFERROR(ArrayFormula(AVERAGE(IF((Orders!$F:$F>=C$1)*(Orders!$F:$F<=(D$1-(1/86400))),Orders!$F:$F-Orders!$E:$E))),"")
  12. Replies
    2
    Views
    160

    Re: Number vs text format using MATCH function

    Maybe something like this.
    This is an array formula and must be entered with CTRL-SHIFT-ENTER.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  13. Replies
    3
    Views
    103

    Re: Help with Nested IF function

    You're welcome. Thanks for the feedback.
  14. Replies
    3
    Views
    103

    Re: Help with Nested IF function

    Try using VLOOKUP

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; ">...
  15. Replies
    7
    Views
    138

    Re: Values only once when multiple values

    Here is another link using a formula.
    https://www.youtube.com/watch?v=IZLAzIYfMDU
  16. Replies
    1
    Views
    557

    Re: Excel stats verses Matlab, R and Python

    Here are some links explaining the difference between R and Excel.
    I personally prefer R over Excel for statistical work. As stated in the links below R does have a steep learning curve.

    ...
  17. Replies
    10
    Views
    343

    Re: hlookup and offset

    Try:

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col...
  18. Replies
    8
    Views
    275

    Re: Index Match Formula

    You could put a boarder around a small part of your file and use copy/paste to paste it to the forum. Are the examples I gave above close to what you have?
  19. Replies
    8
    Views
    275

    Re: Index Match Formula

    Maybe like this.
    If your dates in LXD are actual Excel dates (numeric) then you could use the SUMPRODUCT formula.
    Formula in O82 will work if dates are text or numeric.

    <b>Sheet1</b><br /><br...
  20. Replies
    8
    Views
    275

    Re: Index Match Formula

    You mean something like this?
    This assumes there is only one unique match.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  21. Re: Data Lookup With 3 Criteria Number (Positive,Negative & Zero) Percentage

    Maybe something like this.
    Note: I changed your Grade b, equal to Grade b. zero nunber.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  22. Replies
    5
    Views
    199

    Re: Math + excel formula

    You're welcome. This link should help explain the formula (starting at about the 4:40 mark).
    https://www.youtube.com/watch?v=27qh1i_kgCY

    Also, this link may help....
  23. Replies
    5
    Views
    199

    Re: Math + excel formula

    Try:
    This is an array formula that must be entered with CTRL-SHIFT-ENTER.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  24. Re: Stuck: Compare worksheet value and output to new file with unchanged AND changed values

    This link will show how to merge the lists without duplicates.
    https://www.get-digital-help.com/2009/06/16/extract-an-unique-distinct-list-from-two-columns-using-excel-2007-array-formula/

    Another...
  25. Re: return text after 2nd occurrence of an equal sign (=)

    With a formula.

    <table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; ">...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4