Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    21
    Views
    276

    When I run your script, it copies the font format...

    When I run your script, it copies the font format in "B". tried it several times, same result. dguillett's script does not do this.
    see attached 1st 3 returns up to line 43
  2. Replies
    21
    Views
    276

    Thanks for help and this info. To help me...

    Thanks for help and this info.
    To help me understand this better, what triggered this clarification? What does this tell me besides the literal statement? Are you saying dguillett's script does it...
  3. Replies
    21
    Views
    276

    maudibe and dguillett Thanks Maudibe's script...

    maudibe and dguillett
    Thanks
    Maudibe's script copies font format from corresponding column B; color, bold, position in cell[center].
    How is this happening? Where in the script does this occur?...
  4. Replies
    21
    Views
    276

    Folks, You are missing my objective. I do not...

    Folks,
    You are missing my objective. I do not want the Min/Max, I want the first and last for each month. Column A is dates and is in order, column B is data/numbers and is NOT in ascending or any...
  5. Replies
    21
    Views
    276

    unclehewie, Thanks. Is there a solution that...

    unclehewie,
    Thanks. Is there a solution that does not involve the extra columns? Can this be done with a single formula?

    dguillett,
    Confused with your reply. Please explain. Thanks.

    Is...
  6. Replies
    21
    Views
    276

    find first and last values with conditions

    Column A is dates in order spanning several years, column B are numbers.
    I need the sum of the last number minus the first number for each month and year.

    I can set the month/year condition with...
  7. RG, My Uninstall button was greyed out because...

    RG,
    My Uninstall button was greyed out because I did not have "Client for MS Networks " highlighted. Again, everything works..
    My OS just does not recognize this as Wi-Fi, to SOME extent. Enough...
  8. Sudo, Your screens are as they should be but...

    Sudo,
    Your screens are as they should be but you can see from my screenshots I do not get the "wireless" button or "security" tab. That is my question. Yes, I get the "connect/disconnect" and I do...
  9. Sudo, When I click on my wireless connection,...

    Sudo,
    When I click on my wireless connection, as you suggested, the screen that comes up is the "status" screen with "properties" button. A normal "status" screen has a "wireless properties" button...
  10. no "wireless" button in Wi-Fi status screen

    Win 8.1
    Wi-Fi works fine, but there is no "wireless" button in Wi-Fi status screen. Without this I cannot save password.

    see attached screen shot.
  11. Replies
    1
    Views
    70

    replace "0" with text

    Formula:
    =(LOOKUP(9E+307,IF(F:F>0,F:F)))-MAX(F:F)

    If the value equals "0", I want to replace the "0" with a text "xx" in the cell, that is, show "xx".
    How do I add this to the formula?
  12. Replies
    2
    Views
    81

    RG, Just what I needed but could not quite get...

    RG,
    Just what I needed but could not quite get correct. Thanks.
  13. Replies
    2
    Views
    81

    Formula returns Fx, I want Ax

    A = Dates
    F = numbers
    Formula = Max(F:F)
    I want to return the corresponding "A" or date of the max number.

    EX)
    A1= 1/1/2014 F1= 10
    A2= 1/7/2014 F2= 50
    A3= 1/20/2014 F3= 16
  14. Replies
    8
    Views
    165

    Thanks everyone for your input but I did not...

    Thanks everyone for your input but I did not state my question clearly. I am trying to replace the "default" grid which apparently is not an option in "format/borders". Is this possible?
  15. Replies
    8
    Views
    165

    Thanks RG but this did not work. The reason I...

    Thanks RG but this did not work. The reason I lost the grids is that I color filled the area and that removes the grids. To re-ask the question, how do I color fill and not lose the grids?
  16. Replies
    8
    Views
    165

    replace default grids

    I have a section that lost the standard grids lines. If I add lines using "format/borders", the grid lines are different than the default grid lines. How can I replace these grids without deleting...
  17. Replies
    8
    Views
    664

    Maud, I had tried that before and no number...

    Maud,
    I had tried that before and no number change had any effect. Still split at "K". Got idea to rerun macro manually and that did it. Previously it was just loading the saved file.
    Duh.....
  18. Replies
    8
    Views
    664

    Maud, How would I get this to split at column...

    Maud,
    How would I get this to split at column "U"?
  19. Replies
    29
    Views
    2,191

    Steve, To clarify, the return is not predictable...

    Steve,
    To clarify, the return is not predictable and may be either a number or a text. Both the result's numbers or texts will vary, depending on the conditions. The value of the cell with the...
  20. Replies
    29
    Views
    2,191

    What can I do if the call may return a number or...

    What can I do if the call may return a number or a string?
  21. Replies
    29
    Views
    2,191

    Steve, It seems the "+" is the basic arithmetic...

    Steve,
    It seems the "+" is the basic arithmetic function. Can I add a non-arithmetic function after GetComment so it will run and give a return? Such as an IF or VLookup function?

    =GetComment...
  22. Replies
    29
    Views
    2,191

    Steve, Ah, ha! That seems to be it. Your...

    Steve,
    Ah, ha!
    That seems to be it. Your solution is also where my mind was going so I could cover all circumstances, essentially a 2 step process.
    1-Get Comment
    2-get value
    I was trying ...
  23. Replies
    29
    Views
    2,191

    Steve, I have been unavailable to follow-up. ...

    Steve,
    I have been unavailable to follow-up.

    The content of the destination cell varies too much to have a script/macro/UDF specific for each, that is why I have not/cannot answer your request...
  24. Replies
    4
    Views
    776

    Maud, Good job, does what I need. Thank you.

    Maud,
    Good job, does what I need. Thank you.
  25. Replies
    29
    Views
    2,191

    Steve, Thanks, but not what I need....

    Steve,
    Thanks, but not what I need.
    A1[worksheet1] has a value of 5 and a comment. - I refer to this cell as the source cell.
    B2[worksheet2] has a value of 9[this may be a simple value or an...
Results 1 to 25 of 170
Page 1 of 7 1 2 3 4