Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. I think my friend can put this on a shared drive...

    I think my friend can put this on a shared drive at the college. Look forward to testing it when you have time to adjust.

    I suspect I need to examine the code in the new version to see how to add...
  2. 43407I will check it out later this evening. ...

    43407I will check it out later this evening. THANKS!!

    Each student should have access to every column (the other students, except their own -- they can't rank themselves).

    So, Student1 should...
  3. Google Doc Spreadsheet with row protection...

    I have a friend who teaches in a local college. He wants to create an S by S matrix in a Google Docs spreadsheet.
    S by S is students by students. So, with 20 students in his class, he wants a 20 x...
  4. Replies
    2
    Views
    102

    Is this what you mean? I put this in C2 of New...

    Is this what you mean? I put this in C2 of New Account Numbers workbook and filled down.

    =INDEX('[Source Workbook.xlsx]Sheet1'!$A$1:$A$13,MATCH(B2,'[Source Workbook.xlsx]Sheet1'!$B$1:$B$13,0),1)...
  5. Replies
    3
    Views
    106

    I expect/thought/wanted INDEXing to work for...

    I expect/thought/wanted INDEXing to work for this, but I couldn't get it to handle the array formula. SIGH.
    Maybe I did something wrong and will keep looking at it.

    I used this solution...
  6. If the Citation is in a cell in the Excel file, I...

    If the Citation is in a cell in the Excel file, I see no reason why you cannot insert the field code on that page.
  7. AFAIK, you can only merge from one Excel...

    AFAIK, you can only merge from one Excel spreadsheet. You'll have to take your data that is across several different sheets or workbooks and put it into ONE workbook/spreadsheet with unique headings...
  8. Two good thoughts which were what I initially...

    Two good thoughts which were what I initially thought were the only/best ways. Andrew's other idea is worth my considering, but not sure it that's worth the tricky effort involved. Will see. ...
  9. Replies
    3
    Views
    101

    What about: =SUMPRODUCT((A98='Rec inj and cat...

    What about:

    =SUMPRODUCT((A98='Rec inj and cat 3 above import'!K8:K2000)*(WEEKDAY('Rec inj and cat 3 above import'!$I$8:$I$2000)=1))

    [need the same number of cells in the range]
  10. Replies
    3
    Views
    101

    In what cell is the result of the sumproduct? ...

    In what cell is the result of the sumproduct?

    Not quite sure what you're trying to count.
  11. 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...
  12. [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...
  13. Replies
    0
    Views
    72

    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...
  14. Replies
    3
    Views
    244

    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.
  15. Replies
    3
    Views
    244

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

    Well, I kinda forced this without trying to condense it. Seems to work. Take a look.
  16. 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)
  17. 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.
  18. 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).
  19. Replies
    2
    Views
    103

    [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...
  20. 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...
  21. 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...
  22. 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)
  23. 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...
  24. Replies
    2
    Views
    405

    HowardC, try this: ...

    HowardC, try this:

    =VLOOKUP(A5,INDIRECT("[Br1Tbsept" & $C$1 &".xls]Sheet1!$A$1:$D$100"),4,FALSE)
  25. 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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4