Excel Wizards, please help
22 November 2006, 12:33 PM
#1
Scooby Regular
Thread Starter
Join Date: Sep 2001
Location: A big town with sh1t shops: Northampton
Posts: 21,366
Likes: 0
Received 0 Likes
on
0 Posts
Excel Wizards, please help
Hi,
I have an excel problem and I'm hoping someone will be able to help. I can do a few things with it, but this is a bit beyond me!
Basically I have 2 spreadsheets with names and addresses on, called "A" and "B". I need to know which names on "A" are also on "B" and to end up with a list of names who are only on "A".
Does that make sense? Is it possible?
Thanks in advance. I will get bonus points for this and Christmas is coming......
Cheers
Clare
I have an excel problem and I'm hoping someone will be able to help. I can do a few things with it, but this is a bit beyond me!
Basically I have 2 spreadsheets with names and addresses on, called "A" and "B". I need to know which names on "A" are also on "B" and to end up with a list of names who are only on "A".
Does that make sense? Is it possible?
Thanks in advance. I will get bonus points for this and Christmas is coming......
Cheers
Clare
22 November 2006, 12:49 PM
#2
Scooby Regular
Join Date: Sep 2006
Location: Worthing..
Posts: 7,575
Likes: 0
Received 0 Likes
on
0 Posts
http://office.microsoft.com/en-us/ex...CL100570551033
This details how to do it better than I could - but in essence it is the same thing
This details how to do it better than I could - but in essence it is the same thing
22 November 2006, 01:01 PM
#4
Scooby Regular
Thread Starter
Join Date: Sep 2001
Location: A big town with sh1t shops: Northampton
Posts: 21,366
Likes: 0
Received 0 Likes
on
0 Posts
Another one:
How can I merge info from 2 cells into one without losing data, i.e. first name and last name into one cell without cutting and pasting them all. I've done this before years ago, but can't remember!
Excel help is quite hard to search if you don't know what you're asking for!
Cheers
Clare
How can I merge info from 2 cells into one without losing data, i.e. first name and last name into one cell without cutting and pasting them all. I've done this before years ago, but can't remember!
Excel help is quite hard to search if you don't know what you're asking for!
Cheers
Clare
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM