Pierre-Louis Jolicard

less info
10 reputation
14
bio website
location
age
visits member for 1 year, 9 months
seen Feb 5 '13 at 8:45

Oct
9
awarded  Notable Question
Feb
5
awarded  Commentator
Feb
5
comment Excel List: How to Populate a column function of several others looping until a value is found
Thank you very much!
Feb
5
accepted Excel List: How to Populate a column function of several others looping until a value is found
Jan
23
awarded  Popular Question
Jan
16
comment Excel List: How to Populate a column function of several others looping until a value is found
I intend to combined the index and the match formulas but Isblank doesn' t retruns an array. I'm using a table so I need to use the notation of tables. The hard part for me is to start from my column and loop to the left until I find a value in a cell
Jan
16
asked Excel List: How to Populate a column function of several others looping until a value is found
Jul
19
awarded  Scholar
Jul
19
accepted Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
Jul
19
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
Thank you Julian.
Jul
19
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
My computer is using the ODBC component I configured well. I sent the excel to someonelse who didn't configure anything and she got rejected with: [Microsoft][OBDC Driver Manager] Data source name not found and no default driver specified
Jul
19
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
The guys supporting SharePoint don't want / forbid us to use SharePoint designer. Based on the tuto I've found, it's not possible without SharePoint Designer. Return to square 1.
Jul
19
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
Installing an ODBC component makes it work just fine ... on my laptop only. They do get an error message, something about the component missing which is, I have to admit, obvious.
Jul
18
awarded  Student
Jul
18
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
I can look for something like that, thank you, I'll keep you posted
Jul
18
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
The excel file will be distributed through email or posted our internal SharePoint besides the data is of very little interest outside our organization. I don't bother too much about security at this stage. Finding a web server though can be a little more challenging for me.
Jul
18
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
That would work ... if I had any knowledge in one of those techno. Do you have examples of what you did that a noob like me could copy?
Jul
18
comment Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration
I tried that but when they try to refresh they get asked for the ODBC component
Jul
18
asked Excel & MySQL: How to create a connection to MySQL for which user receiving the excel file don't have to do any configuration