298 reputation
111
bio website assylias.wordpress.com
location London, United Kingdom
age 37
visits member for 2 years, 9 months
seen Dec 20 at 12: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.

Oct
19
awarded  Scholar
Oct
19
comment Excel find bucket without nested IFs
You have inverted the 2 ranges in your formula, it should be =LOOKUP(A1,Z2:Z10,Y2,Y10) - otherwise it works fine, thanks.
Oct
19
accepted Excel find bucket without nested IFs
Oct
19
asked Excel find bucket without nested IFs
Sep
11
answered Why is updated Java running old version?
Aug
22
comment Ubuntu 12.04 desktop
You should try on askubuntu.com
Aug
15
awarded  Excavator
Aug
15
revised What is the easiest way to keep an offline copy of a webdav share?
Pointing to home page instead of obsolete version
Aug
15
suggested approved edit on What is the easiest way to keep an offline copy of a webdav share?
Jul
18
comment Cell does not automatically reflect the result of a formula
Are you on automatic calculation mode: File > Excel Options > Formulas > Calculation options > Automatic?
Jul
9
comment Excel 2007 - cannot open the clipboard
Probably superuser. I have voted to migrate your question there.
Jul
9
comment Excel 2007 - cannot open the clipboard
Check this thread - the last answer might work.
Jul
9
comment Excel 2007 - cannot open the clipboard
Same here - very annoying. But probably off topic for SO.
Jul
2
awarded  Commentator
Jul
2
comment Excel: How to treat multiple lines as one while sorting?
@Excellll absolutely, thanks. That's what happens when you don't test your code / formulae ;-)
Jul
2
revised Excel: How to treat multiple lines as one while sorting?
edited body
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.