GuenMat Tools

Excel Multi-instance
Launch Regedit
First:
• Go to HKEY_CLASSES_ROOT \ Excel.Sheet.12 \ Shell \ Open
• Delete key DDEEXEC
• Open key COMMAND
• Delete the default value "command"
• Double click on"(by default)"
• Add a space then "%1" (with the quotes) such as
C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Then
• Go to HKEY_CLASSES_ROOT \ Excel.Sheet.8 \ Shell \ Open
• Delete key DDEEXEC
• Open key COMMAND
• Delete the default value "command"
• Double click on"(by default)"
• Add a space then "%1" (with the quotes) such as
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
• Close REGEDIT
ui-button

Pivot table
To enable data on the same line (same as columns), right click on the sheet, the select "Pivot table options".
Go to the "Display" pane, and tick "Classic disposition ..." and validate.
Finally, right click on displayed totals to hide them if they are not needed.
ui-button

How to retrieve numbers between parentheses
For cells values such as "XXXXXX (XXX)", use the formula:
=STXT($L2;TROUVE("(";$L2)+1;TROUVE(")";$L2)-TROUVE("(";$L2)-1)
Look for data according to an ID
Use the following formula
=RECHERCHEV(A2;datarange;n;0)
with the values
• A2 : the celle with the ID
• datarange : the range of data where we are looking for the id and the data. The ID must be in the first column.
• n : the column where the value is located if the ID is found
• 0 : for perfect match
ui-button

Select all data in sheet
Type the following command on a cell
CTRL + A
or from the up left cell
CTRL + MAJ + FIN
Then you can right click on the selected values and set a name to be used in formula later.
ui-button