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.
Joined: Feb 27 2002 Posts: 5442 Location: Aberdeen
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
“You are playing a game of football this afternoon but more than that you are playing for England, and more even than that, you are playing for right versus wrong. You will win because you have to win. Don’t forget that message from home. England expects every one of you to do his duty.”
Joined: Mar 08 2002 Posts: 26578 Location: On the set of NEDS...
Hopie wrote: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.
Hopie wrote: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
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.
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.
Big Graeme wrote: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.
"Let only those who enter do so with pride and the determination to uphold the traditions of the club".
//www.FaxFans.co.uk //www.halifaxrlfc.co.uk
Halifax Tag RL. Interested in playing? Visit //www.pitchero.com/clubs/halifaxcommunityrugbyleague/
Joined: Mar 08 2002 Posts: 26578 Location: On the set of NEDS...
Nat (Rugby_Aholic) wrote: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.
Wonderful, had the first bit but the share vanished when rebooted. Thanks
Nat (Rugby_Aholic) wrote: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.
Wonderful, had the first bit but the share vanished when rebooted. Thanks
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?
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?
Users browsing this forum: No registered users and 145 guests
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
