Type the forumula below, follow instructions but type commas and brackets and =vlookup

=vlookup(click first cell of list of new employee id numbers,highlight entire column of old employee id numbers,1,false)

Press enter. But then go back into the formula and put a dollar sign before the cell and row references in the old employee id numbers bit (E.g $D$4:$D$50 if info was in rows 4-50 of column D) then drag formula down the list of new id numbers to copy the formula down. Anything that returns an id number is in both, anything that comes back as N/A is not in both lists.

Networking Mac and PC's...

Anyone know how to make a Mac connect to disk shares on another machine (Windows) on boot? Got it to work the other way round without a problem.

i just got hold of a new netbook with windows seven, it is severely slow just running an internet browser - first windows seven ive had so can anyone point me to a helpful walkthrough/faq for checking what is running in the bacground and how to remove the usual junk a new machine comes with

Best thing you can do is upgrade from 1GB of RAM to 2GB of RAM if your machine can take it.

Other things to do -

Run msconfig and stop everything apart from your AV starting a boot.

All the Windows netbooks I've seen have come with the power management options set to power saver or balanced to prolong battery life, with them being portable and all.

Switching it to 'high performance' when plugged in works a treat. As mentioned by BG upgrade the memory and ensure there is no bloatware running. Most new laptops will have all kinds of extras running, security software, backup software, media software, desktop widgets etc.

Can you connect to the share from the mac manually?

Yup, not what i want the end users to be doing though, I want them to reconnect at start up.

Quote: Big Graeme "Networking Mac and PC's... Anyone know how to make a Mac connect to disk shares on another machine (Windows) on boot? Got it to work the other way round without a problem.'" Samba, comes as default on both OS's. Basically on the Mac you need to Go > Connect to Server and use smb://sharepc/sharename. Once you have connected manually drag the network volume from your desktop to the Login Items in Preferences > Accounts > Login Items. This will then connect when you log on again.

Quote: Big Graeme "Networking Mac and PC's... Anyone know how to make a Mac connect to disk shares on another machine (Windows) on boot? Got it to work the other way round without a problem.'" Samba, comes as default on both OS's. Basically on the Mac you need to Go > Connect to Server and use smb://sharepc/sharename. Once you have connected manually drag the network volume from your desktop to the Login Items in Preferences > Accounts > Login Items. This will then connect when you log on again.

Is there any way to look at the data held behind the UI on the Super League 'Head to Head' statistics page (www.superleague.co.uk/statistics_player) I'm looking to draw comparisons between more than 2 players at a time, if there was any way for me to be able to look at all the information held and manipulate it as required using Excel or whatever that would be perfect, just not sure if that's possible?

Is there any way to look at the data held behind the UI on the Super League 'Head to Head' statistics page (www.superleague.co.uk/statistics_player) I'm looking to draw comparisons between more than 2 players at a time, if there was any way for me to be able to look at all the information held and manipulate it as required using Excel or whatever that would be perfect, just not sure if that's possible?

If there security is up to much, I'd doubt it. Unless of course they're providing that level of information somewhere on the site and I've missed it.

Failing that you could scrape it, bit naughty though.

To be honest, legality aside, I'd have no idea where to start with web scraping so that's out of the question.

I had guessed it would be nigh on impossible for a novice like me, thought I'd ask the question anyway! Cheers though, I'll just have to grind it out manually.

morning folks;
got an old laptop that I need to "flatten" and rebuild, any tips on a quick and easy way to do it?

Let Windows do the work mate, at install choose to delete the existing partition and create a new one.

Someone posted a link to a driver backup program earlier in the thread, I would suggest doing that so you don't have to find all your drivers again once your done, however updating the would be no bad thing.