2,774 reputation
21136
bio website wyevalenurseries.co.uk
location Hereford, United Kingdom
age 34
visits member for 3 years, 1 month
seen Nov 17 at 8:31

Been involved in IT support since school/college and worked for many years (13) doing on-site network, hardware and desktop support in homes and businesses. Now doing IT Support & Stock Control in a Wholesale Plant Nursery.

Interests: Hardware (& Overclocking), Cars, Gaming


Nov
7
accepted Excel COUNTIF range search returning #N/A
Nov
7
comment DHCP issues, possibly related to Netgear N300 (DGN2200)
The new router REPLACED the old router, it should be the only DHCP server and I only want my IP's within the 192.168.1.x subnet. Sorry, I should have been more clear - my troubleshooting is to find out if there is another device on the network (that I am unaware of) running DHCP.
Nov
7
comment Lossless rotation of photos using Windows Photo Viewer? (XP vs Win7)
Thanks for the downvotes without offering alternatives!
Nov
7
asked DHCP issues, possibly related to Netgear N300 (DGN2200)
Oct
24
awarded  Yearling
Sep
30
awarded  Explainer
Aug
28
reviewed Approve suggested edit on Disc not bootable after creating a Windows partition with Bootcamp
Aug
28
comment Excel COUNTIF range search returning #N/A
IFNA did fix my problem, so it would be the ideal solution to my formula. But I have now changed that formula to do the task much more tidily (see other answers).
Aug
27
answered Excel COUNTIF range search returning #N/A
Aug
27
comment Excel COUNTIF range search returning #N/A
Thanks cathoo, it sounds as if I need to explore other functions! A colleague has a different solution to my problem. I'll expand on his answer in my own answer to the question.
Aug
27
asked Excel COUNTIF range search returning #N/A
Jul
2
awarded  Curious
Jun
6
comment Microsoft Office Compatibility Pack “The converter failed to open the file” error & “This is a pre-release version”
Hi pac, I'm under the impression you can install any of the compatibility packs under 2000, but only through trying to open an .xlsx file (or .docx etc) will you know if the converter is working. I even encountered some strange errors with a 'beta' version of the compatibility pack (and messages about it expiring), but it is not one of the versions listed above.
Jun
6
comment Excel using INDEX and LIST to return multiple results
Sorry guys, I was under the impression I couldn't use VLOOKUP as it would only return 1 result! Seems my google search was wrong and it can! Thanks & apologies for the duplicate.
Jun
5
asked Excel using INDEX and LIST to return multiple results
Mar
31
awarded  Notable Question
Feb
20
comment How to connect a desktop SATA harddrive to laptop?
It would only be bootable (I believe) if attached via eSATA and not really by USB. USB would be possible but you would need to reconfigure multiple parts of windows to get it setup. USB would also be very slow, obviously USB2 & 3 are quicker, but still no match for SATA speeds!
Dec
11
revised Lossless rotation of photos using Windows Photo Viewer? (XP vs Win7)
Clarification
Dec
11
comment Lossless rotation of photos using Windows Photo Viewer? (XP vs Win7)
I have amended my answer to explain, in my experience it's 'close enough' but all depending on your application and what you are using the images for will depend on how close this is.
Nov
18
awarded  Famous Question