Search:

Type: Posts; User: Aladin Akyurek; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 1.92 seconds.

  1. Replies
    1
    Views
    85

    Re: Formula for multiple conditon

    Would you post 5 rows from that separate table?
  2. Re: Excel formula if number between two values return different values

    Something like:

    =LOOKUP(D3,{0,3.6,7.5,11.01},{1,0.6,0.4,"?"})
  3. Re: Display a list only with the values by country

    In C18 control+shift+enter, not just enter, and copy down:
    ...
  4. Re: Modifying a (sum, indirect, substitute, address, column), formula?

    In S1 enter and copy across:

    =LOOKUP(9.99999999999999E+307,$A$1:A1)

    which is faster.
  5. Re: Is there a SUM-minus formula instead of SUMPRODUCT?

    Control+shift+enter, not just enter:

    =SUM(IF(ISNUMBER(A2:A5*B2:B5),B2:B5-A2:A5))
  6. Re: sumif or sumproduct based on current month and year

    You are welcome.





    Could you custom format the result cell (the formula cell) for example as:

    #,##0.00_);(#,##0.00)
  7. Re: sumif or sumproduct based on current month and year

    Control+shift+enter, not just enter:


    =SUM(IF(ISNUMBER(V:V),IF((MONTH(V:V)=8)*(YEAR(V:V)=2019)*ISNUMBER(SEARCH("paypal credit",P:P)),AI:AI)))
  8. Re: sumif or sumproduct based on current month and year

    Which column is it and what is the text you are looking for?
  9. Re: Excel Multiple Search and return Non Array formula

    That's right. Sort D:E together, ascending on D.
  10. Re: Return column of far most right value in a row

    If A1:Z1 is numeric:

    =LOOKUP(9.99999999999999E+307,A1:Z1)

    If A1:Z1 is text:

    =LOOKUP(REPT("z",255),A1:Z1)

    If A1:Z1 may house any value including blanks:
  11. Re: Excel Multiple Search and return Non Array formula

    Sort D:E in ascending order on column E...

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  12. Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

    Either: Control+shift+enter, not just enter...

    =TEXTJOIN(", ",TRUE,IF(ISNUMBER(SEARCH(List,$A2)),List,""),"")

    Or, if you don't have TEXTJOIN on your Excel version, let's try the following:

    ...
  13. Replies
    27
    Views
    824

    Re: AverageIfs Complexity

    You need to apply control+shift+enter at the same time.
  14. Replies
    27
    Views
    824

    Re: AverageIfs Complexity

    Control+shift+enter, not just enter:


    =AVERAGE(IF(LEFT($B$2:$B$150,1)+0=3,$G$2:$G$150))
  15. Replies
    1
    Views
    187

    Re: Help unstanding this formula?

    Try to test with a smaller data area, say, A1:D5, on Sheet1. Enter some data in A1:D5 and also some small numbers in F. Enter the adjusted formula in G1 as:
    ...
  16. Re: sumif or sumproduct based on current month and year

    1. Control+shift+enter is an Excel requirement for signaling Excel that the formula in question is an array-processing formula. Excel's calculation treats such formulas differently (qua algorithms it...
  17. Re: How to always Reference Cell even if deleted?

    Try:

    =IF(ISNUMBER(INDIRECT("C14")),EOMONTH(INDIRECT("C14"),0),"no date")
  18. Replies
    2
    Views
    175

    Re: Vlookup on multiple matches

    The desired output does not seem to show any structure. If thi observation is correct, any random output should be acceptable for a given look up value!
  19. Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

    Please try to continue this one in https://www.mrexcel.com/forum/excel-questions/893600-extract-multiple-keywords-text-string-3.html. Thank you.
  20. Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

    You are welcome.
  21. Re: sumif or sumproduct based on current month and year

    Control+shift+enter, not just enter:

    =
    SUM(IF(ISNUMBER(V:$V),IF((MONTH(V:$V)=8)*(YEAR(V:$V)=2019),AI:$AI)))
  22. Replies
    14
    Views
    16,358

    Re: Array Formula to Remove Zero Value Rows

    Try to provide a small input sample along with the output which must obtain from that sample.
  23. Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  24. Re: Formula to Create a List from and Existing List ignoring zero values

    You are welcome.
  25. Re: Return Multiple Column headings in a single Cell

    Excel 2013 does not have the TEXTJPOIN function, hence the #NAME ? error. Try the following instead...

    Add the following VBA code to your workbook as a module, using Alt+F11...

    Function...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4