# Search:

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

Page 1 of 20 1

## Search: Search took 0.06 seconds.

by kweaver
Replies
4
Views
69

### 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...

by kweaver
Replies
4
Views
69

### 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...

by kweaver
Replies
4
Views
69

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. ## Thread: Formula to extract new account number

by kweaver
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. ## Thread: sumproduct: 0 vs valid value (Excel 2010)

by kweaver
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. ## Thread: Mail Merge - 3 page document - multiple records (grouping)

by kweaver
Replies
4
Views
190

### 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. ## Thread: Mail Merge - 3 page document - multiple records (grouping)

by kweaver
Replies
4
Views
190

### 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. ## Thread: Establishing desired formatting from client document based on a master document formats

by kweaver
Replies
3
Views
146

### 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. ## Thread: Help with nesting Sumproduct and Countifs

by kweaver
Replies
3
Views
101

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

=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. ## Thread: Help with nesting Sumproduct and Countifs

by kweaver
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. ## Thread: Establishing desired formatting from client document based on a master document formats

by kweaver
Replies
3
Views
146

### 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. ## Thread: Is this a Word or Excel issue? Mail Merge font problem.

by kweaver
Replies
0
Views
59

### [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. ## Thread: Mail Merge font issue

by kweaver
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...

by kweaver
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.

by kweaver
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. ## Thread: Returning a value in the last filled row of a particular column

by kweaver
Replies
5
Views
259

### 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. ## Thread: Summing one column by choosing the cell marked by another column

by kweaver
Replies
5
Views
175

### 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. ## Thread: Summing one column by choosing the cell marked by another column

by kweaver
Replies
5
Views
175

### 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. ## Thread: Excel formatting hekp

by kweaver
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. ## Thread: Summing across multiple worksheets based on variable data

by kweaver
Replies
11
Views
654

### 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. ## Thread: Summing across multiple worksheets based on variable data

by kweaver
Replies
11
Views
654

### 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...

by kweaver
Replies
4
Views
362

### 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. ## Thread: Box/Gridlines from Excel when pasting into email/Word

by kweaver
Replies
4
Views
501

### 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. ## Thread: Using indirect formula within Vlookup

by kweaver
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. ## Thread: Word Mailmerge / Different certificates in one document

by kweaver
Replies
2
Views
487

### 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