Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.30 seconds.

  1. Thread: IF Formula help

    by Fluff
    Replies
    2
    Views
    8

    Re: IF Formula help

    How about
    =MAX(A1:B1)
  2. Re: how to keep from exiting sub with this code?

    Do you have any code between those two snippets?
  3. Re: For columns where row 1 returns FALSE, select, clear, delete cells in rows 10:54

    Ok, if you change the formula in row 1 to
    =IF(VLOOKUP(S10,"Table above",2, FALSE ),"",FALSE)
    you can use
    Sub danoz()
    Intersect(Rows("10:54"), Range("S1:AT1").SpecialCells(xlFormulas,...
  4. Re: Returning multiple results match with no duplicates

    Glad you sorted it & thanks for the feedback
  5. Re: Changing row color in a conditional formatting

    You're welcome & thanks for the feedback
  6. Re: Returning multiple results match with no duplicates

    In that case if its returning "" it sounds like the value in E2 cannot be found in col A
    Check that you don't have any leading/trailing spaces.
  7. Replies
    6
    Views
    37

    Re: Cycling through find results in a loop

    Change the filter criteria.
  8. Re: Returning multiple results match with no duplicates

    What is the formula you are using & what are the ranges?
  9. Replies
    3
    Views
    66

    Re: Formula seperators

    Have you checked the Language setting in File > Advanced > Language
  10. Re: Changing row color in a conditional formatting

    If you select all the data & use a formula like
    =$O2<0
    it will highlight the row.
  11. Re: Returning multiple results match with no duplicates

    That's exactly what the formula does.
    Please define "did not work"
  12. Replies
    6
    Views
    37

    Re: Cycling through find results in a loop

    With a filter you filter the three columns, so it shows you every row that contains all 3 values.
    You can then modify the data as needed.
  13. Re: Remove red indicators from notes excel 2016

    Not sure that's possible.
  14. Re: Label Change Color When Text in cell is "true" on userform

    In your latest file, you have changed all the command button codes, so none of them work!
  15. Re: Remove red indicators from notes excel 2016

    Goto > File > Options > Advanced > scroll down to "Display" > select "No comments or indicators"
  16. Re: Label Change Color When Text in cell is "true" on userform

    Can you please post the code that is not working & explain why?
  17. Replies
    6
    Views
    37

    Re: Cycling through find results in a loop

    Why not just use either Autofilter, or advanced filter?
  18. Re: Formula to convert Oz back into autosum and add to left of decimal place

    Maybe something like

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  19. Re: Label Change Color When Text in cell is "true" on userform

    Is it working?
    If not what problems do you get?
  20. Re: Returning multiple results match with no duplicates

    Hi & welcome to MrExcel.
    How about

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  21. Re: VBA code to set font color to match background color

    You're welcome & thanks for the feedback
  22. Replies
    1
    Views
    9

    Re: INDEX MATCH formula HELP

    Hi & welcome to MrExcel.
    In D2 copied down & across
    =IFERROR(INDEX($B$5:$I$5,AGGREGATE(15,6,(COLUMN($B$5:$I$5)-COLUMN($B$5)+1)/(($A$6:$A$7=$A2)*($B$6:$I$7=$B2)),COLUMNS($A$1:A$1))),"")
  23. Re: VBA code to set font color to match background color

    How about
    Sub kellymort()
    Dim Cl As Range
    For Each Cl In Range("A20:O68")
    Cl.Font.Color = Cl.Interior.Color
    Next Cl
    End Sub
  24. Thread: Elseif issue

    by Fluff
    Replies
    6
    Views
    156

    Re: Elseif issue

    Then you either have to unprotect it, select as unlocked cell, or use a different method.
  25. Re: VBA Code, how to define range of found column header properly

    You filling the entire columns with a white background & then looping through the columns & checking if the background is NOT white.
    As it will always be white, the inner loops never trigger.
    Try...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4