Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data lists

Data lists

ResolvedVersion 2010

Wed 14 Mar 2018, 16:27 Delegate Carl said...

Carl has attended:
Excel Intermediate course
Excel Intermediate course

Data lists

How would I take 3 separate excel workbooks or worksheets within one workbook containing lists of addresses in order to create one new sheet that contains a list of all the common/same addresses that appear on all 3 lists?

Many thanks in advance

Thu 15 Mar 2018, 14:13 Trainer Wendy said...

RE: Data lists

Hi Carl

Thank you for using the forum

Have you tried using a VLOOKUP or Index and Match to match up the data?

We have an article on Vlookups here
https://www.stl-training.co.uk/fg-30/vlookup-vs-hlookup.html

and you can download the manual that covers it here
https://www.stl-training.co.uk/excel-advanced-courses.php #free-manual

Please let me know if this helps

Kind regards

Wendy Canelas
Microsoft Trainer

Thu 22 Mar 2018: Automatically marked as resolved.

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Data lists

Data lists

RE: Data lists

Excel articles

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010