Jean-François Corbett

less info
236 reputation
17
bio website
location Copenhagen, Denmark
age 37
visits member for 2 years, 10 months
seen 2 days ago

I'm a physicist working in wind energy at GL Garrad Hassan.


Mar
28
awarded  Citizen Patrol
Mar
14
asked Log off to apply display changes
Mar
14
answered Windows 7 Explorer: how to show total size of all files in current folder?
Jan
24
comment X axis labels with “super-categories” or “headers”
Thanks; I wanted to know how to do this manually, by which I mean, without relying on Excel's automated behaviour.
Jan
24
answered X axis labels with “super-categories” or “headers”
Jan
24
awarded  Editor
Jan
24
revised X axis labels with “super-categories” or “headers”
added 191 characters in body; edited title
Jan
23
comment X axis labels with “super-categories” or “headers”
You know, when a cell happens to be selected when you insert a chart; if that cells happens to be in an area with data, then Excel will take a guess at what your chart should look like and make that automatically. That's what happened to me.
Jan
23
asked X axis labels with “super-categories” or “headers”
Jul
27
comment How can I set Excel to always import all columns of CSV files as Text?
Great answer. Very complete.
Jun
29
awarded  Yearling
Jun
19
comment Excel 2010, How do I write this formula? Data is on a different worksheet, same workbook
I like the --<boolean expression> trick to convert from boolean to 1 or 0. I've seen IF(<boolean expression>,1,0) before, but -- is more succint and actually more readable once you get used to it. Actually, let me edit your answer to clarify this (and many other things...)
Apr
5
awarded  Scholar
Apr
5
accepted Why would the TEMP environment variable contain more than one path?
Apr
2
asked Why would the TEMP environment variable contain more than one path?
Dec
7
comment How to get a string from a cell?
Press F1, type "text functions" and read up.
Sep
5
asked Change Windows 7 taskbar location automatically based on screen shape or on docking status
Jan
25
awarded  Supporter
Nov
28
comment Using Excel to create a record of my paychecks
True, but this particular question isn't a programming question. Dmitry Beransky is right (if for the wrong reasons). This is a textbook SuperUser question. @alf: Total number of Excel question is irrelevant; that may be due to any number of other factors: superuser is newer than stackoverflow, there is less traffic on superuser in general, fewer excel questions are being asked than excel-vba questions, etc. None of this makes this particular question more programming-related. Voting to close.
Oct
28
comment Zero values in Excel logarithmic chart: Can the warning be suppressed?
Unfortunately, until my company decides to upgrade to 2010, it is a requirement!