784 reputation
18
bio website
location Warrington, UK
age 34
visits member for 1 year, 9 months
seen yesterday

Jul
3
answered Most efficient way to search a computer
May
21
comment Excel Return Max Text Value Using VLOOKUP
Use this formula wherever you think your MIN would go.
May
21
answered Excel Return Max Text Value Using VLOOKUP
Apr
22
awarded  Caucus
Mar
13
comment How can I make Chrome work more like Firefox?
Actually, I always thought that Chrome had this right, putting everything in one bar - Fx's search box feels cramped by comparison. I went the other way, installing OmniBar in Firefox to have one bar for URLs and search.
Feb
28
revised How do I make page number in footer to be away 2cm from content?
added image inline
Feb
28
suggested suggested edit on How do I make page number in footer to be away 2cm from content?
Feb
27
answered How to automatically copy randomly generated text from a website
Feb
27
comment How do I change my audio output device without making it the default one?
I upvoted you but I lack the power to accept your answer, since I'm not the original questioner. Sorry!
Feb
27
comment How do I change my audio output device without making it the default one?
This is much better than the (potentially error-prone) AutoHotKey approach. Also, you don't have to compile it on your own - it's just a tray application to install. Works perfectly for me!
Feb
24
answered I want to find if a value on one spreadsheet is also in another spreadsheet
Feb
18
answered How to list recent places items without explore then
Feb
18
comment Finite looping a video file in quicktime or MP4 container and keeping file size down to single loop original size?
It sounds like the sort of job that AviSynth would handle quite nicely. Essentially you have a text file which your player handles as a video file. You can specify finite loops of a particular video file inside the AviSynth file.
Feb
18
answered Excel Keystroke shortcut; Appending Text At End Of Current cell
Jan
30
revised Excel function for calculating total spent time
added 56 characters in body
Jan
30
comment Excel function for calculating total spent time
Ah - I didn't realise that - thanks! I'd never heard of EXACT(). Every day's a schoolday :)
Jan
29
comment Paste a range into a filtered table
+1 for not using VBA.
Jan
29
comment Unmodifiable windows shortcut link : how to alter them?
Looks as if it is a symbolic link, rather than a normal shortcut. You can't modify symlinks, only create or destroy them (I think). And you have to be admin. More info: en.wikipedia.org/wiki/NTFS_symbolic_link
Jan
28
comment Excel - sum the contents of multiple alphanumeric cells
That's quite a cumbersome formula. I would have an extra cell for each one and just sum them at the end, or you can use @Jerry's array formulae. And as he shows, you can use IFERROR to parse the empty cells.
Jan
28
answered Excel - sum the contents of multiple alphanumeric cells