Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Thread: sorting

    by KevCarter
    Replies
    41
    Views
    1,461

    Re: sorting

    My apologies, I didn't realize how old this thread was. I just found Peter's earlier sorting solution to be a wonderful response...
  2. Thread: sorting

    by KevCarter
    Replies
    41
    Views
    1,461

    Re: sorting

    Peter, what a clever solution! Cheers.
  3. Replies
    3
    Views
    180

    Re: Vlookup for excel 2016 on mac

    It works for me. I'm using Excel 365 on an older MacBook Pro.
  4. Replies
    3
    Views
    180

    Re: Vlookup for excel 2016 on mac

    The same shortcut works on the mac.

    Here is a web page with all the keyboard shortcuts for both mac & windows.

    ...
  5. Replies
    13
    Views
    490

    Re: Stop excel workbook from opening

    Thomas, I've not seen the exact scenario you have, but another area where old pasted data can hang around and cause problems is the Name Manager in the Formulas tab. You can easily see any errors...
  6. Replies
    5
    Views
    417

    Re: ROWS does not spill?

    Hi Brian,

    Does this work for you?


    =SEQUENCE(ROWS(A1:A3))

    I love the new array structure!
  7. Thread: Random name

    by KevCarter
    Replies
    5
    Views
    238

    Re: Random name

    What an AMAZING Formula!!!
  8. Replies
    43
    Views
    32,575

    Re: Trying to pair names randomly into teams??

    Happy to help Andrew!
  9. Replies
    43
    Views
    32,575

    Re: Trying to pair names randomly into teams??

    Matt,

    I'm not sure how to change the macro around for this task, but here is a sheet that handles flights several ways using formulas. I think it's pretty slick. A generous forum member helped me...
  10. Replies
    43
    Views
    32,575

    Re: Trying to pair names randomly into teams??

    PERFECT! Thank you Mick.
  11. Replies
    43
    Views
    32,575

    Re: Trying to pair names randomly into teams??

    MickG,

    Would you please help me with a very rookie question? I'm not really sure how the following line of code works. You are adding the background fill here:

    Dn.Resize(,...
  12. Replies
    15
    Views
    2,727

    Re: It was twenty years ago today...

    WOW, 20 years of helping Excellers of all levels, including boneheads like me. Thank you very much for so kindly sharing your knowledge, and for creating an environment where so many others can share...
  13. Re: How to add Round function with IF condition ?

    Happy to help!
  14. Re: How to add Round function with IF condition ?

    Please try:



    =ROUND(IF(I8>=2,2*13500.3,IF(AND(I8=0,IK8<=2),6800*K8,IF(I8=0,6800*2,IF(I8+K8<=2,(I8*13500)+(K8*6800),IF(I8+K8>2,(I8*13500)+(6800*(2-I8))))))),0)
  15. Replies
    2
    Views
    205

    Re: Personal Macros

    Good deal. Thank you Mark!
  16. Replies
    2
    Views
    205

    Personal Macros

    Iím ashamed to say Iím very late to this party. I have the same macros in many workbooks, and donít want to delete them if I donít need to...

    If I have a macro in a workbook that has the same name...
  17. Replies
    15
    Views
    444

    Re: Index Match function to find outliers

    Thank you, I'm just really good at copy/paste. :) We can learn so much from Girvin, Jelen, and everybody on this forum like Mark and SheetSpread!!!
  18. Replies
    15
    Views
    444

    Re: Index Match function to find outliers

    Agree. However, in my real world projects, I go with something like your helper column example whenever possible. In my opinion, much easier to look at later and remember what's happening if I need...
  19. Replies
    15
    Views
    444

    Re: Index Match function to find outliers

    I really like the examples given by SheetSpread and Markmzz above. I'm learning and wanted to go through the exercise. Another example not requiring CSE thanks to Mike Girvin's videos:

    Also using...
  20. Re: Pulling Data from a sheet into a userform

    Tony,

    I like to set my values in the initialize event of the user form. Just another option...


    Sub AAA_Calender1_tests()
    UserForm1.Show
    End Sub
  21. Re: Pulling Data from a sheet into a userform

    Tony,

    Please try:


    UserForm1.TextBox1.Value = ThisWorkbook.Worksheets("Form Info").Range("A1").Value
  22. Replies
    3
    Views
    150

    Re: Index(match frustration

    You may need to run it twice to test, no big deal unless it's a huge dataset. Try something like:

    ...
  23. Replies
    20
    Views
    843

    Re: Why doesn't my If And formula work?

    Donna, untested, but please try this:


    =IF(AND(O8>=95,O8<=100),25,IF(AND(8>=85,O8<=94),20,IF(AND(O8>=70,O8<=84),15,IF(AND(O8>=50,O8<=69),10,IF(AND(O8>=30,O8<=49),58,IF(O<=29,0))))))
  24. Re: RANK variable blocks of cells between BLANK cells

    Absolutely amazing!!!
  25. Re: DATA VALIDATION: dropdown "x" and no more that one "X" in the range

    My apologies, I must have misunderstood your question.
Results 1 to 25 of 64
Page 1 of 3 1 2 3