# Search:

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

Page 1 of 4 1

1. ## Thread: compare two lists

by Wordnewby65
Replies
11
Views
534

### I am not sure it can be done in a formula. See...

I am not sure it can be done in a formula.
See my last post

If it can I'd be interested to see the solution as well.

Thank you for all your time and effort.
2. ## Thread: compare two lists

by Wordnewby65
Replies
11
Views
534

### OK a few more questions. 1. Are the lists the...

OK a few more questions.

1. Are the lists the same size? No
2. Do you want then extracted to a new position? yes
3. Are you hoping to do this with a Formula Or Macro? formula since I don't know...
3. ## Thread: compare two lists

by Wordnewby65
Replies
11
Views
534

### Do mean extract to a new location or just find...

Do mean extract to a new location or just find out which ones do not have a match?

You can use VLOOKUP with an IF to determine items in list A that are not in list B
But it will not directly...
4. ## Thread: compare two lists

by Wordnewby65
Replies
11
Views
534

### Greetings, I have list A and list B, some...

Greetings,

I have list A and list B, some items in list A are the same as those in list B. How can I extract the ones that do not match?

Thank you.

by Wordnewby65
Replies
4
Views
414

### That's so awesome. I did know Sum function can...

That's so awesome. I did know Sum function can do that. Danke very much!

by Wordnewby65
Replies
4
Views
414

### Morning Hans, I tried your suggestion and I...

Morning Hans,

I tried your suggestion and I got #VALUE! as the result. Do you know why? =SUM(Mar!D8:Apr!D8)

by Wordnewby65
Replies
4
Views
414

### I'm not sure if I'm using the correct formula for...

I'm not sure if I'm using the correct formula for what I need. Each tab has monthly data that represents the number of hours each staff member spent on a project. For my YTD tab, I'm trying to find...
8. ## Thread: How do you suppress the Personal.xlsb worksheet?

by Wordnewby65
Replies
2
Views
769

### Thank you for the million and one times:)

Thank you for the million and one times:)
9. ## Thread: How do you suppress the Personal.xlsb worksheet?

by Wordnewby65
Replies
2
Views
769

### Every time I open any Excel file it will...

Every time I open any Excel file it will automatically default to the Personal.xlsb spreadsheet. How do I remove this?

TIA
10. ## Thread: Copy and drag problem

by Wordnewby65
Replies
2
Views
331

### oh my goodness..I feel stupid. Danke Hans!

oh my goodness..I feel stupid. Danke Hans!
11. ## Thread: Copy and drag problem

by Wordnewby65
Replies
2
Views
331

### I have an Excel file and I wanted to create...

I have an Excel file and I wanted to create another Excel file for a different department but only want certain information to be linked between the file. I've been manually linking one cell (this...
12. ## Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
574

### Thank you all. I was able to fix my problem by...

Thank you all. I was able to fix my problem by placing the cursor on the header of the missing page, select page layout/breaks/page and then update. Thanks again:)
13. ## Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
721

### Yes, it is the right graph. It works for the...

Yes, it is the right graph. It works for the other graphs. This is driving me to drink:) Never the less, thank you for your time. I'll just delete that graph and start over.
14. ## Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
721

### I tried what you suggested. If I just paste then...

I tried what you suggested. If I just paste then I get the curent graph but if I paste special then I get the previous graph...ughhh..this is killing me. I need the graph to be linked. Is this a...
15. ## Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
721

### Thank you Hans.

Thank you Hans.
16. ## Thread: Copy and Paste issue between Word and Excel

by Wordnewby65
Replies
8
Views
721

### I'm not sure If this a Word or an Excel issue. ...

I'm not sure If this a Word or an Excel issue.

I'm trying to copy a graph/chart from Excel and paste special with paste link/Microsoft excel spreadsheet object. After the 4th graph it only will...
17. ## Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
574

18. ## Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
574

### It does use Heading 1. I'm unable to send an...

It does use Heading 1. I'm unable to send an attachment since that report is large..60 pages. I need to find a way for TOC to differentiate between pages. It almost like Word thinks page 9 and 10 are...
19. ## Thread: Missing pages from TOC

by Wordnewby65
Replies
7
Views
574

### Could someone tell me why some pages are...

Could someone tell me why some pages are missing/skip from my table of contents and how to fix it? Thank you.

by Wordnewby65
Replies
6
Views
481

### Thank you for your explanation. I'll take an...

Thank you for your explanation. I'll take an aspirin now:)

by Wordnewby65
Replies
6
Views
481

### would it burn any more of my brain's cells? ...

would it burn any more of my brain's cells? apparently you know I don't have that much left. btw, congratulations on the new Woody's. It looks great but the people behind it that makes it much...

by Wordnewby65
Replies
6
Views
481

### The formula works great but I tried to evaluate...

The formula works great but I tried to evaluate your formula but it appears that I need assistance to put them in laymen terms or me?

TIA.

by Wordnewby65
Replies
6
Views
481

### I'm trying to find a date formula that would give...

I'm trying to find a date formula that would give me the date of the 2nd Wednesday of each month. I was able to narrow it down to this formula but some dates are correct and some dates are off.
...
24. ## Thread: Query issues (2003)

by Wordnewby65
Replies
6
Views
498

### Re: Query issues (2007)

Thank you..you're awesome! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
25. ## Thread: COUNT calculation (2003)

by Wordnewby65
Replies
1
Views
402

### COUNT calculation (2003)

There's a database that allows the user to type in a date parameter in the Form. I've been manually counting the number of business days within the parameter. If I want to add a count calculation,...
Results 1 to 25 of 98
Page 1 of 4 1