FreePint: Join
Join FreePint and receive the Newsletter every two weeks for free.
Join now »
|
My Account »
|
|
If you find FreePint useful, please supply
a testimonial »
|
|
FreePint Family:
Monthly magazine reviewing business information products »
Articles, tools, and a monthly magazine, to give you practical help with information skills »
Recruit for information-related roles, or find your next challenge. »
Daily update of web-based resources »
Daily update of free, full-text reports »
|
|
|
|
Home > Forum > Bar > Message |
|
|
Join FreePint and receive the twice-weekly Bar Digest and twice-monthly tip-packed Newsletter. It's free. [ more ]
|
|
|
|
The FreePint Bar is generously sponsored by Dow Jones Factiva.
|
|
|
| Start New | Message Index | Flat View |
| Excel question |
| Author: | Toots |
| Date: | Monday, 13th Aug 2007 13:41 |
| Views: | 1,042 (excluding Digests and RSS feeds) |
| Category: | Computers and Software | | URL: | http://www.freepint.com/go/b170005 |
|
Greetings Pinters,
I need to see what data in
workbook1,sheet1,columnC is also in workbook2,sheet5,columnU.
Or to see what data in workbook1,sheet1,columnC is NOT in workbook2,sheet5,columnU.
Thank you so much.
Toots
Who can' t think of a clever signature |
|
| Start New | |
| Topic |
Author |
Date |
ID |
 | Excel question | | Greetings Pinters,
I need to see what data in
workbook1,sheet1,columnC is also in workbook2,sheet5,columnU.
Or to see what data in workbook1,sheet1,columnC is NOT ... |
|
Toots |
13/08/07 13:41 |
170005 |
 | Re: Excel question | | Have you tried ExcelTips ( http://exceltips.vitalnews.com )? A search on "comparing data workbooks" gets some hits though I'm not ... |
|
Nick Guy |
15/08/07 11:46 |
170712 |
| | Re: Excel question | |
Do you have MS Access?
If so, you can import both spreadsheets into Access.
You can then run a Duplicates Query and ... |
|
Donald Lorr |
13/08/07 18:32 |
170085 |
| | Re: Excel question | | Thank you, Donald. I do have Access, though I have never used it even once.
I was hoping there was some ... |
|
Toots McDonough |
13/08/07 18:48 |
170086 |
| | Re: Excel question | | Not Lazy, at all.
Just trying to use your time better.
We all have too much other work to do than to ... |
|
Donald |
13/08/07 19:13 |
170092 |
| | Re: Excel question | | There is a way of doing it and using vlookup is the answer.
The formula is: =VLOOKUP(A1,Sheet2!A:A,1,FALSE)
where the cell you want ... |
|
James |
14/08/07 15:52 |
170374 |
| | Re: Excel question | | Hi James,
Thanks. I was hoping to use something simple like that. But the problem is that the data I want ... |
|
Toots |
14/08/07 16:07 |
170377 |
| | Re: Excel question | | Two possibilities here.
1. change the columns around when you run the function
2. in my example before I used the number ... |
|
James |
14/08/07 16:12 |
170381 |
| | Re: Excel question | | Dear James,
I'm hoping that it is possible to do this without manipulating the data beyond entering the function in the ... |
|
Toots |
14/08/07 19:00 |
170420 |
| | Re: Excel question | | Toots
Excel Spreadsheet Search Engine
I liked the idea of pidgin excel so much that I created an
Google Co-Op Excel ... |
|
Tom Szczepanik |
14/08/07 23:26 |
170530 |
| | Re: Excel question | | Dear Tom,
Thank you for this fantastic resource. Within the first five results, using your search terms, I found a quick ... |
|
Toots |
15/08/07 15:08 |
170773 |
Please note: The reply form is not showing because the posting is older than six months or the thread is locked. Please start a new topic or contact the forum administrator.
|
|
