Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Comparison for imported data

	98.1 % recommend us
	More live stats...

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

Training information:

Comparison for imported data

Resolved · Medium Priority · Version 2007

Reply Thu 2 Feb 2012, 17:20Delegate Tina said...

Tina has attended:
Excel Advanced course

Comparison for imported data

I am trying to make a comparison between two sets of data, however the unique data are numbers formated as text. I seem to be unable to reformat the numbers to numbers rather than text.
I have tried to use a pivot table to eleminate duplications then a VLOOKUP to make the comparison but it keeps coming up with errors. Am I using the correct tools?
How would you suggest I proceed?

For upcoming training course dates see: Pricing & availability

Reply Mon 6 Feb 2012, 10:18Trainer Anthony said...

RE: Comparison for imported data

Hi Tina, thanks for your query. Sounds a lot like your source data needs to be "washed", i.e. reformatted so it can be used correctly. Your workarounds are good, but if all else fails use conditional formatting to highlight duplicates or copy and paste the data into Word and do a document comparison.

Hope this helps,

Anthony

Mon 13 Feb 2012: Automatically marked as resolved.

Excel articles

· Conditional Formatting in Excel 2007
· Some Lesser Known Time Saving Tips In Excel
· How To Avoid The Embarrassment Of Dirty Data
· Tracking In Excel 2003
· Radio Buttons And Check Boxes In Excel

Please browse our web site to find out more about
microsoft+excel+training+london and other Microsoft training courses.

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips