Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Comparind data

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training onsite - Comparind data

Resolved · Low Priority · Version Standard

Reply Fri 10 Aug 2007, 11:41Delegate Fazil said...

Fazil has attended:
Excel Advanced course

Comparind data

Hello,

I have 2 different workbooks/worksheets with data about my clients. I want to know if those workbooks/worksheets have data about the same customer. How do I find it..?

I cant merge the worksheets/workbooks as the data apart from client name are different.

Thanks and regards... Fazil

For upcoming training course dates see: Pricing & availability

Reply Fri 10 Aug 2007, 12:25Trainer Amanda said...

RE: Comparind data

Hi Fazil

Thanks for your question.

If you simply want to find something in particular in a spreadsheet you can use the Find feature. Ctrl + F will open the Find feature or you can go to Edit - Find.

Then type in what you are looking for and Excel will select the next instance of what you are looking for in the spreadsheet.

I hope this helps.

Amanda

Reply Mon 13 Aug 2007, 09:53Delegate Fazil said...

RE: Comparind data

Thanks Amanda..,

The spreadsheets I am talking about runs the data of thousands of customers and so it is difficult to compare each customer name using Ctrl + F. It is equally difficult to compare them by minimising to display side-by-side in the screen as, apart from 'customer name' other data in the spreadsheets are very different.

Is there a way to tell 'Excel' to run through both the spreadsheets, compare the data on 'Customer Name@ column and report back saying, 'this is the list of customers present in both the spread-sheets'

Thanks and regards,
Fazil

Reply Mon 20 Aug 2007, 09:11Trainer Amanda said...

RE: Comparind data

Hi Fazil

I think this would require VBA code to be written in order to produce the results that you are looking for.

Amanda

Excel articles

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Identifying Suitable Candidates For VBA For Excel Training
· Backstage Management With Excel 2010
· Basic Excel Training
· Data Validation In Excel

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips