Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.42 seconds.

  1. Re: Vlookup not working and it's driving me MAD!!!

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

    M.
  2. Replies
    3
    Views
    46

    Re: inventory values to update

    You are welcome. Thanks for the feedback.

    M.
  3. Replies
    3
    Views
    46

    Re: inventory values to update

    Maybe...



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

    Welcome to Mr Excel Forum

    Dates as mm/dd/yyyy


    A
    B
    C
    D
    E
  5. 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.
  6. 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
  7. Re: Defining an Array Within a Formula

    You are welcome. Glad to help.

    M.
  8. 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.
  9. Replies
    4
    Views
    81

    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.
  10. Re: Sum numbers in cell seperated by a comma

    You are welcome. Thanks for the feedback.

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

    Maybe this...



    A
    B

    1
    Text
    Sum
  12. Replies
    11
    Views
    407

    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
  13. Replies
    11
    Views
    407

    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...
  14. Replies
    2
    Views
    64

    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.
  15. Re: Formulas to count including Unique Numbers

    To use an OR condition in an array formula you should add the conditions, for example
    ...
  16. Replies
    11
    Views
    407

    Re: Issue with rank formula

    Result #N/A???? Don't understand how a formula using SUMPRODUCT can generate such result :confused:, unless there are errors or blank rows in your data. Check.

    Worked perfectly for me...


    ...
  17. Replies
    11
    Views
    407

    Re: Issue with rank formula

    Maybe...

    E2 copied down...
  18. Thread: YTD Sum

    by Marcelo Branco
    Replies
    2
    Views
    100

    Re: YTD Sum

    Maybe

    Project 7 Actual YTD
    =SUMIFS(INDEX($C$4:$O$11,MATCH(B14,B$4:B$11,0),0),C$3:O$3,"<="&B$3)
    where B14 = Project 7

    Project 3 Budget YTD...
  19. Replies
    7
    Views
    154

    Re: Moving Match formula

    You are welcome. Thanks for the feedback.

    By the way, a more robust formula (it handles non-existent items)

    C9 copied down...
  20. Replies
    7
    Views
    154

    Re: Moving Match formula

    This is a different requirement :confused:
    What really do you want? Item A Band 2 or Band 3?

    M.
  21. Replies
    7
    Views
    154

    Re: Moving Match formula

    Maybe something like this...



    <tbody>


    A
  22. Re: MIN & MAX Formula with Multiple Variables

    Maybe something like this

    Sheet1


    <tbody>


    A
  23. Re: MIN & MAX Formula with Multiple Variables

    Are the dates m/d/yy or d/m/yy?


    M.
  24. Re: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

    Then you should use the solution suggested above by Fluff or VBA. Unfortunately, as far as I know, a formula can't identify a colored cell.

    M.
  25. Re: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

    What is the criterion (logic) that is used to manually color cells green? Greater than a certain value? Does it contain some keyword? Or any other criteria (?)
    I believe they are not randomly...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4