Alexandre P. Levasseur

less info
179 reputation
6
bio website raisonsociale.net
location Montreal, Canada
age 26
visits member for 2 years
seen Jun 2 at 21:35

I am an accounting systems analyst for a Canadian bank. I have studied accounting and business administration in Montreal and my experience in programming includes a little bit of many languages / technologies (PHP, C++, C#, VBA).

I work daily with VBA and many different versions of the Office suite (2000 to 2007) though I am still very much learning VBA.


Nov
18
revised How to get e-mail alerts from multiple e-mail boxes
edited title
Nov
18
awarded  Tumbleweed
Nov
11
asked How to get e-mail alerts from multiple e-mail boxes
Sep
2
answered Define constant and use in Excel 2010 formula
Jun
20
answered How to draw a chart for date wise row count
May
12
awarded  Citizen Patrol
May
11
comment Combining two Excel sheets
Can you group the "duplicates" on one same sheet together ? Because then it's a simple matter of using SUMIF. If not, that's another story because there is no identifier to separate two entries for the same store on one sheet.
Jan
4
comment Computer freezes when editing links in Excel
This is more of a SU question. You open that Excel file so that Excel does not have to do it everytime it needs to update its values. Close it when you're done.
Jan
1
comment Mapping of child elements
I'm sorry I tried my best to make it as clear as possible but it is quite a complex problem. Elements starting with "FD" are parents and elements with only 5 characters are children. If a parent has a mapping associated with it then all its children should have the same mapping except if the child was specifically assigned another label.
Jan
1
asked Mapping of child elements
Dec
27
awarded  Editor
Dec
27
revised EXCEL: How to conditional format a thick bottom border to an entire row based on one column value?
edited body
Dec
27
answered EXCEL: How to conditional format a thick bottom border to an entire row based on one column value?
Dec
24
comment Changing cell values based on another cell
@toti You need to tell us a bit more. How many conditions or statuses are there ? Is it only cell A1 that you will modify and expect the other cells to follow ? What should happen if the value entered is something else than 0 or 1 ?
Dec
24
comment Changing cell values based on another cell
@Naresh : I would -1 that comment if I could. OP asks for conditional logic. Your formula breaks on his second case (if it's zero).
Dec
13
awarded  Teacher
Dec
12
answered Pressing down arrow jumps to top of Excel spreadsheet
Oct
2
comment work with huge 15000 lines excel files containing formulas
But yes, we'd need to know what formulas you are using. Maybe even a link on the workbook if possible.
Oct
2
comment work with huge 15000 lines excel files containing formulas
It's not always possible to use a database for this sort of thing. For example at work we use the Essbase spreadsheet add-in and that can easily generate 10-30-40k lines of data in Excel. Putting all that data in Access for processing just to spit it out in Excel for reporting purposes (because Access does not let you control your report as much as Excel would) seems overkill.
Jul
12
awarded  Supporter