Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    10
    Views
    169

    Frankly, I'm still lost on what it is you're...

    Frankly, I'm still lost on what it is you're trying to select. On Sheet1, there is no W10 cell. There is a merge of V10:X10 which maybe you think is W10 because the merge incorporates that cell...
  2. Replies
    10
    Views
    169

    I might be overlooking something in your...

    I might be overlooking something in your description, but I don't see any data in W10 on Sheet1.

    It's unclear to me what you're trying to insert in Sheet4 (and where) with a VLOOKUP.
  3. Replies
    13
    Views
    273

    Maudibe...nice work!!

    Maudibe...nice work!!
  4. Replies
    7
    Views
    1,036

    39909 Try unchecking "border lines" in the...

    39909

    Try unchecking "border lines" in the autocorrect section of Options.

    To remove the existing ones, put the cursor above them and touch DELETE on the keyboard.
  5. Try going to Options > Advanced > General and see...

    Try going to Options > Advanced > General and see if "ignore other applications that use DDE" is checked.
    If so, uncheck and see if that resolves the issue.
  6. Replies
    10
    Views
    256

    Thanks, Gordon. That is almost ideal. How did I...

    Thanks, Gordon. That is almost ideal. How did I miss that transparent option in 2010? Hmmm.

    It messed with the outline of the certificate, but I think I can adjust sufficiently to make the...
  7. Replies
    10
    Views
    256

    Maud, was that a "background" or did you do some...

    Maud, was that a "background" or did you do some other magic? Was the image tiled or was this just one image?
    Does your image also print with the spreadsheet?
  8. Replies
    10
    Views
    256

    This needs a specific graphic of a certificate.

    This needs a specific graphic of a certificate.
  9. Replies
    10
    Views
    256

    I've tried inserting a rectangle in the entire...

    I've tried inserting a rectangle in the entire print area and then replace the background in the rectangle and make it fairly transparent, but I end up with the entire graphic transparent which isn't...
  10. Replies
    10
    Views
    256

    Yes, Maud...but I don't want to put it as a...

    Yes, Maud...but I don't want to put it as a "background" and have it tile itself 4 times.
    Was this just one image? That's what I'm looking for but don't see how to make it behind the cells like you...
  11. Replies
    10
    Views
    256

    Graphic behind cell data

    I do NOT want a background tiled all over the spreadsheet, but DO want an image to be in a sheet but have the cell data "show through."
    I read repeatedly that this cannot be done in Excel. By 2010...
  12. Replies
    25
    Views
    504

    Oops. I was using different test numbers. Sorry. ...

    Oops. I was using different test numbers. Sorry. Problem is, I think the OP wanted the single results not a difference showing up in each row. So, a comparison of the months like I did would have...
  13. Replies
    25
    Views
    504

    Doesn't calculate the right answer(s) for me on...

    Doesn't calculate the right answer(s) for me on the sample spreadsheet.
  14. Replies
    25
    Views
    504

    I found this interesting to do in one column. I...

    I found this interesting to do in one column. I don't know if this is overkill or not, but it worked using the file from unclehewie.

    It's an array formula that I filled down starting in row TWO....
  15. Append new row of select data from one sheet to another

    I suspect this needs a macro.

    I have a template sheet (called "Dispatch"). A user enters data in various cells.
    I'd like a button that takes specific cells from the template sheet and places...
  16. Replies
    7
    Views
    208

    Yes, Maud, the Friday and Monday would be counted...

    Yes, Maud, the Friday and Monday would be counted if the dates are 9/11/14 - 9/15/14.
  17. Replies
    7
    Views
    208

    The start date is never included in the...

    The start date is never included in the calculation. I've managed to handle it, however.
  18. Replies
    7
    Views
    208

    With 9/11/14 and 9/15/14 I get -29924 but can't...

    With 9/11/14 and 9/15/14 I get -29924 but can't see where the fix needs to be (not enough coffee yet).

    KW

    Sorry...was trying it in A1 and B1...not DOWN the A column. However, 9/11/14 - 9/15/14...
  19. Replies
    7
    Views
    208

    Odd lapsed days algorithm needed.

    I have a situation where the start date (A1, for example) and end date (B1) exist.
    The start date is never calculated in the lapsed days.

    If the start date and end date include ONE weekend, the...
  20. [SOLVED] If I understand this correctly, how about: ...

    If I understand this correctly, how about: =SUMPRODUCT((N1:N4=">0-1")*T1:T4)
  21. Replies
    12
    Views
    528

    (as a former NYer)...when the elevator doesn't...

    (as a former NYer)...when the elevator doesn't arrive as quickly as you expect, you press the button again ... repeatedly.
  22. Replies
    2
    Views
    103

    I think I solve it! YEAH!! Not as dumb as I...

    I think I solve it! YEAH!! Not as dumb as I look....LOL
  23. Replies
    2
    Views
    103

    breakout stacked data to single rows

    Best to look at the attachment while reading this.

    The real data file has several thousand rows. The listings are medical professionals and detailed data.
    The breakdown is by PA County which is...
  24. Replies
    18
    Views
    458

    Yes, RG, the data came from an internet source. ...

    Yes, RG, the data came from an internet source. I realized when I was doing this manually and then doing some look-ups on the data that there were unusual lengths, so in my master file I created a...
  25. Replies
    18
    Views
    458

    Here is a sample with only 1 tab and...

    Here is a sample with only 1 tab and substantially reduced in row number.

    Kevin
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4