151 reputation
6
bio website
location
age
visits member for 1 year, 9 months
seen Jun 23 at 13:11

May
27
awarded  Student
May
23
comment Query parameters in an external connection to sql server
@PeterMunnings Would you mind writing up the full procedure you used to get it working with a simple query as an answer please?
May
23
comment Query parameters in an external connection to sql server
@PeterMunnings I couldn't find any other way besides using VBA. Although in the end we stuck with a button rather than a cell change trigger to make it more obvious that there is VBA behind it
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
just tried that. No good for me I'm afraid :(
Feb
14
revised Page appears centered at 120% zoom but on the left at 100%
edited title
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
A colleague has the identical screens to me, same resolution, but his is centered by default.
Feb
14
revised Page appears centered at 120% zoom but on the left at 100%
added 40 characters in body
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
But how do I make this the default behaviour? If I do this, then I can zoom with the mouse wheel (holding control) and it stays centered, but if I click on that zoomy bar in the bottom right then it reverts back to the left.
Feb
14
asked Page appears centered at 120% zoom but on the left at 100%
Jan
28
comment How to link N*M cells in MS-excel? (F4 function for $ in a matrix)
So click on cell A1, press F4, and then drag it down and across.
Jan
28
comment How to link N*M cells in MS-excel? (F4 function for $ in a matrix)
Is this a single array formula? Is it a formula that has been auto-filled (dragged down)? Or are these completely independent formulae?
Nov
19
comment Excel Multiplication
@MatthewS. you should use multiple columns as J_D says. For example keep your original values in ColA, your multipliers in ColB (so can easily be unique for each row) and then in ColC it's just =A1*B1. Then you can just find the average of ColC
Nov
19
answered How to open Excel 2010 as separate files
Nov
19
accepted Offset the tickmarks of a secondary axis
Nov
8
revised Offset the tickmarks of a secondary axis
added 236 characters in body
Nov
8
answered Offset the tickmarks of a secondary axis
Nov
8
awarded  Editor
Nov
8
revised Offset the tickmarks of a secondary axis
added 1 characters in body
Nov
8
asked Offset the tickmarks of a secondary axis
Aug
15
awarded  Commentator