vlookup.xlsx

<div>
hey Wesley, did you achieve your goal with this?
</div>


hey Wesley, did you achieve your goal with this?

<div>
So sorry guys - thanks for the help - perfect answer!
</div>


So sorry guys - thanks for the help - perfect answer!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have 2 lists of students from 2 dates. List 1 contains students enrolled on 2nd September. List 2 has list of students enrolled on 6th September.<br />
<br />
I have inputted the students from List 1 into our own departmental database, and need to enter the people enrolled in the days after 2nd September from the 6th September list (List 2).<br />
<br />
I have messed about with duplicates and filters, but cannot quite find what i need to solve this puzzle!<br />
<br />
Is there a straightforward way to highlight the differences between the 2 lists as list 2 contains list 1 plus new enrollees?<br />
<br />
Thanks for your help in advance<br />
<br />
Wesley
</div>
</div>


Hi,

I have 2 lists of students from 2 dates. List 1 contains students enrolled on 2nd September. List 2 has list of students enrolled on 6th September.

I have inputted the students from List 1 into our own departmental database, and need to enter the people enrolled in the days after 2nd September from the 6th September list (List 2).

I have messed about with duplicates and filters, but cannot quite find what i need to solve this puzzle!

Is there a straightforward way to highlight the differences between the 2 lists as list 2 contains list 1 plus new enrollees?

Thanks for your help in advance

Wesley

Excel - Removing duplicates in lists (perhaps comparing?)

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.