348 reputation
211
bio website assylias.wordpress.com
location London, United Kingdom
age 37
visits member for 2 years, 10 months
seen Jan 27 at 15:43

My work combines statistics and programming.

  • I am the author of jBloomberg, a high level wrapper around the Bloomberg Desktop Java API
  • my blog is a combination of those passions.

Jul
2
answered Excel: How to treat multiple lines as one while sorting?
Jun
21
answered Joining / nesting excel if statements in Excel
Jun
12
comment Date axis with a partial year
I am away for a few days. Will try when I'm back. Thanks!
Jun
8
comment Date axis with a partial year
Nice try - but Dec-01 appears on the left of the vertical axis which is a bit messy.
Jun
8
awarded  Critic
Jun
8
comment Date axis with a partial year
@DavidVandenbos Yes precisely. I could do without the first mark (Feb-02) if it makes it easier, but the first interval would still be 10 months.
Jun
8
asked Date axis with a partial year
May
31
comment How can I create matrices of data in Excel?
Not sure I understand what you are asking. It seems the numbers in the "Column index" column are irrelevant. You basically create a row with x,y,z,p ordered by their "Row Index", then copy that row 4 times, is that it?
May
3
awarded  Organizer
May
3
revised Auto completion in a drop down list in Excel 2007
more specific title + added tag
May
3
suggested approved edit on Auto completion in a drop down list in Excel 2007
Apr
25
awarded  Editor
Apr
25
revised Highlight current date in expense manager in Excel 2010
added 50 characters in body
Apr
25
answered Highlight current date in expense manager in Excel 2010
Apr
25
comment Highlight current date in expense manager in Excel 2010
Have you tried using conditional formatting?
Apr
22
comment Copy top level group rows only
I don't think this is possible without using vba...
Mar
27
comment excel ignores system list separator
You could do it in C# but it should be fairly straightforward and fast enough in VBA.
Mar
27
comment excel ignores system list separator
Then VBA it is I suppose. Let us know if you have problems adapting the examples I linked to.
Mar
27
answered excel ignores system list separator
Mar
19
comment Transposing data in Excel
Is First name supposed to be Abbruzzese Gabriele? Also do you mean row or column?