151 reputation
7
bio website
location
age
visits member for 2 years
seen Oct 13 at 6:56

Sep
12
comment Google Chrome is adding a slash to my searches
@Cory I reported it as an issue to Chrome asking them to make an exception if this is indeed a new feature. Perhaps you should too. Under the chrome menu -> Help -> Report Issue
Sep
11
comment Google Chrome is adding a slash to my searches
I have this same issue, does this come from a recent chrome update? I'm sure I did not used to experience this. It's extremely irritating
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
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
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.
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
Aug
15
comment Query parameters in an external connection to sql server
@DaveRook Yes I've tried it, for OLE DB drivers it looks like there just isn't an option for parameters. The button is greyed out. My approach is fine but what a mission to write a bunch of macros when Excel can probably do it for me. Plus macros are less robust, if I move the cell then I have to go and manually change all the references in the code.
May
7
comment How to locate Matlab installation?
It means open Matlab and type matlabroot inside matlab I would think
Mar
28
comment Excel cell formatting to fill color
Google conditional formatting in excel and just use that exact same formula
Nov
12
comment Putting a line feed in a string built in an excel formula in a data label
Cool no worries, you can do it manually by clicking on the data lables them selves twice and then typing in the formula bar but I had 50 points hence the VBA. I'll post my VBA code for posterity.
Nov
12
comment Putting a line feed in a string built in an excel formula in a data label
Wait but then where do you put the series name which is the first parameter in my SERIES() function? And also if you are just referencing one single cell, then you only get one datalabel no? I need all of points to have labels referencing different cells, so replace NSS!$I$34 with a range. But looking at your formula, it seems like you are trying to get the linebreak in the series name, not a datalable. I have solved this with VBA, but if there is a way to not I'm keen to hear it.
Nov
12
comment Putting a line feed in a string built in an excel formula in a data label
OK I see the advantage of setting it with that DATASERIES formula but it gives me an error. I'm using excel 2012. If I click on a series the formula I get is this: =SERIES("Floating Rate Notes",NSS!$I$35:$I$85,NSS!$L$35:$L$85,5) I have tried adding the data label range as a parameter in a few places but nothing works, and also I tried changing SERIES to DATASERIES but also no good. Any ideas?
Nov
12
comment Putting a line feed in a string built in an excel formula in a data label
=A1 & Chr(10) & B1 works perfectly in VBA as well as I mentioned in my question. Solving this in VBA is not the problem but thanks anyway. Also vbNewLine works which is probably the most readable choice if you use VBA.
Nov
12
comment Putting a line feed in a string built in an excel formula in a data label
The DATASERIES part is unnecessary, all I needed was to put the line break in a cell and then make the data label reference that cell. So =A1&CHAR(10)&B1 in a word wrapped cell (say C1) and then in the data label just =C1 works. I'm not sure if this is what you were saying in your answer but I'm going to mark it as correct, perhaps you can edit it to reflect this comment.
Nov
12
comment Putting a line feed in a string built in an excel formula in a data label
No, but if I reference a cell with a line break then it seems to work