Search:

Type: Posts; User: Marcelo Branco; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.50 seconds.

  1. Replies
    25
    Views
    1,474

    Re: Find next whole number in list

    Maybe...



    A
    B
    C
    D

    1
  2. Re: Return a specific sum through duplicate list entries

    Try

    <tbody>


    A


    B
  3. Re: Vlookup ---> then QTY Extact match or Greater Qty

    You are welcome.

    M.
  4. Re: Vlookup ---> then QTY Extact match or Greater Qty

    You are welcome. Glad to help.

    To understand what the formula does, step by step, try
    Formulas > Evaluate formula

    M.
  5. Re: Vlookup ---> then QTY Extact match or Greater Qty

    Try



    A
    B
    C
    D
    E
    F
  6. Re: List w/ Multiple Occurrences, Based on a Variable

    You are welcome. Glad to help.

    M.
  7. Re: List w/ Multiple Occurrences, Based on a Variable

    Try



    A
    B
    C
    D

    1
  8. Re: Automatically highlighting conflicting/overlapping times on same dates

    I hadn't seen that...

    Try
    Select your data, say A2:D20 (not the headers)


    A
    B
    C
    D
  9. Re: Automatically highlighting conflicting/overlapping times on same dates

    Maybe...


    <tbody>


    A


    B
  10. Re: Automatically highlighting conflicting/overlapping times on same dates

    Is this a typo?

    <tbody>
    Workshop

    18/08/2020

    15:00-18:00

    </tbody>
  11. Re: Vlookup not working and it's driving me MAD!!!

    See if this helps
    https://www.contextures.com/xlFunctions02.html#trouble

    M.
  12. Replies
    3
    Views
    65

    Re: inventory values to update

    You are welcome. Thanks for the feedback.

    M.
  13. Replies
    3
    Views
    65

    Re: inventory values to update

    Maybe...



    A
    B
    C
    D
    E
    F
  14. Re: SUMIFS Across Rows with Multiple Criteria

    Welcome to Mr Excel Forum

    Dates as mm/dd/yyyy


    A
    B
    C
    D
    E
  15. Re: Formulas to count including Unique Numbers

    Graham,

    This thread is getting too long...
    New data? I suggest you create a new thread - new data sample along with expected results.

    M.
  16. Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

    Maybe something like this...



    A
    B
    C
    D
    E
    F
  17. Replies
    3
    Views
    127

    Re: Defining an Array Within a Formula

    You are welcome. Glad to help.

    M.
  18. Replies
    3
    Views
    127

    Re: Defining an Array Within a Formula

    To create a vertical array with 5 single results you can try something like

    CHOOSE({1;2;3;4;5},result1,result2,result3,result4,result5)

    M.
  19. Replies
    4
    Views
    107

    Re: If, and, or

    Maybe this array formula...

    =AND(B3="V",SUM(IF(MOD(COLUMN(AF3:AX3)-COLUMN(AF3)+1,2)=1,IF(AF3:AX3="B",IF(ABS(Q3-AQ3:BI3)<=2.25,1))))>0)
    confirmed with Ctrl+Shift+Enter, not just Enter

    M.
  20. Re: Sum numbers in cell seperated by a comma

    You are welcome. Thanks for the feedback.

    M.
  21. Re: Sum numbers in cell seperated by a comma

    Maybe this...



    A
    B

    1
    Text
    Sum
  22. Replies
    11
    Views
    467

    Re: Issue with rank formula

    If the cities are grouped and there are no blank rows in the middle, maybe this simpler array formula



    A
    B
    C
    D
    E
  23. Replies
    11
    Views
    467

    Re: Issue with rank formula

    This scenario - multiple cities with the same value and different ranks - and adding the possibility of blank cells, requires a complex array formula. Would this be convenient for you? Or would it...
  24. Replies
    2
    Views
    85

    Re: Skills Matrix equation help

    Maybe i'm not understanding what you need but it seems to me you can simply use
    =(U8-14)*0.11

    M.
  25. Re: Formulas to count including Unique Numbers

    To use an OR condition in an array formula you should add the conditions, for example
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4