Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Establishing desired formatting from client document based on a master document formats

    I have a client that sends a Word doc to his clients. His clients fill in blanks (simply by typing) and add and delete sentences, phrases, etc.
    They then send the Word doc back to him. He copies...
  2. [SOLVED] Is this a Word or Excel issue? Mail Merge font problem.

    I don't mean to cross-post here and Word, but I don't know where the issue is.

    I have a multi-page Word 2010 document with field codes to merge from Excel 2010. The entire document is in Arial...
  3. Replies
    0
    Views
    36

    Mail Merge font issue

    I have a Word (2010) document with mail merge fields that pull from Excel (also 2010). The document is in Arial 11 font.

    The Excel file has all of the data in the same font. However, when I...
  4. Replies
    3
    Views
    102

    Someone else will have to provide you with the...

    Someone else will have to provide you with the macro. Not my strength. I ran it with 10,000 lines and the approach I used immediately filled the answers.
  5. Replies
    3
    Views
    102

    Well, I kinda forced this without trying to...

    Well, I kinda forced this without trying to condense it. Seems to work. Take a look.
  6. If I understand you correctly, the F2 grade is...

    If I understand you correctly, the F2 grade is L17 unless there is a final exam posted, then it's L18.

    In F2, does this work? =IF(ISBLANK(B20),L17,L18)
  7. Do you mean in column D you'll put an "x" to mark...

    Do you mean in column D you'll put an "x" to mark those that should be summed? Please clarify.
  8. What about: =SUMIF(D2 : D6,"

    What about: =SUMIF(D2 : D6,"<4",B2:B6) in B9?

    And, similar in C9 (I think you meant C9 rather than C10).
  9. Replies
    2
    Views
    80

    [SOLVED] I'm hoping there's an easier way, but this seems...

    I'm hoping there's an easier way, but this seems to work on a new sheet, filled down and across.

    I put this in the new sheet in A2.

    =IFERROR((VALUE(SUBSTITUTE(SUBSTITUTE('Final...
  10. Good suggestion, RG. If the OP doesn't want to...

    Good suggestion, RG.

    If the OP doesn't want to do your suggestion, what do you think of mine w/the indirect?
    I don't suspect his database will get too large, so this shouldn't be too costly in...
  11. The attached works for three sheets. It's going...

    The attached works for three sheets. It's going to get to be a mess of a formula for 30 days (sheets).
    I thought there would be an array formula that would do this, but haven't been able to...
  12. One way: =SUMPRODUCT(ISBLANK(C3:C9)*B3:B9) and...

    One way: =SUMPRODUCT(ISBLANK(C3:C9)*B3:B9) and adjust the range accordingly.

    Another option: =SUMIF(C3:C9,"",B3:B9)
  13. I think (not totally sure) that if you're using...

    I think (not totally sure) that if you're using OUTLOOK (I'm using 2010), it's using Word as the editor. Then, it considers what you paste as a table.

    I've had this happen to me and the only two...
  14. Replies
    2
    Views
    279

    HowardC, try this: ...

    HowardC, try this:

    =VLOOKUP(A5,INDIRECT("[Br1Tbsept" & $C$1 &".xls]Sheet1!$A$1:$D$100"),4,FALSE)
  15. Interesting question. I think I'd do the mail...

    Interesting question. I think I'd do the mail merge by filtering the Excel file by achieved level and merge into the appropriate Word doc (separate certificates in multiple Word documents). I know...
  16. Replies
    12
    Views
    1,502

    [SOLVED] Are you only looking at the row immediately...

    Are you only looking at the row immediately above?

    Is the attached close?
  17. This is a 2-column process in Excel. Create a...

    This is a 2-column process in Excel.
    Create a column with the numbers from 1 to 20.
    Create another column next to it with =rand() filled down all 20 rows.
    Then, sort the column with the random...
  18. Replies
    12
    Views
    1,454

    I think there's a better chance of being struck...

    I think there's a better chance of being struck by lightening than winning the lottery most places.
    But, as I heard once "you have to be in it to win it."

    Since the lottery doesn't care about...
  19. Replies
    12
    Views
    1,454

    These are all the same theory. If order matters...

    These are all the same theory. If order matters (permutations) or if order does not matter. Lotteries are combinations without repetition, for example. If you have 3 things (e.g., label them "1",...
  20. Welcome to the lounge. Try switching to page...

    Welcome to the lounge.

    Try switching to page layout view once you've set the rows that will print on all pages.
  21. Replies
    12
    Views
    1,454

    That's combinations of 10 things 4 at a time...

    That's combinations of 10 things 4 at a time which is only 210.
  22. Replies
    12
    Views
    1,454

    I think there are 10 options for the first press;...

    I think there are 10 options for the first press; 9 for the second; 8 for the 3rd and 7 for the 4th making the product = 5040 ways.
  23. Replies
    12
    Views
    1,454

    When you say order matters, do you mean the...

    When you say order matters, do you mean the numbers must be increasing as in 1, 2, 3, 4? Can one push the buttons simultaneously or only 1 at a time? Otherwise, I think both of these are the same ...
  24. Thread: Format help

    by kweaver
    Replies
    4
    Views
    132

    From your example attached, I thought you wanted...

    From your example attached, I thought you wanted G9 to S9 to be filled with a color depending on the value in THOSE CELLS. So, do you mean

    the green: =AND((G8-G9)<=10%,(G8-G9)<>0)
    the red: ...
  25. Thread: Format help

    by kweaver
    Replies
    4
    Views
    132

    Conditional formatting with two...

    Conditional formatting with two conditions/formulas after selecting the full range:

    (a) =AND(G9<=10%,G9<>0)
    (b) =G9>=10%
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4