About 9 results (0.0067 seconds)

Sum by week and day with Excel
You need to calculate the sum for the day, and for the week on an Excel sheet. How to proceed to get the results to these calculation automatically ...
How to get the average of the last 5 values in Excel
How to obtain the average of the last x cells in the Excel software and thus see if there is an evolution with our data compared to other averages, ...
Count the number of occurrence in Excel
How to count the number of occurrence of values in a column? For example we have a list of towns in the A column. Among this towns, some ...
Excel VBA, test of the And (&)
In an Excel VBA, how to detect a cell with a & character in a For loop ? You don’t necessarily need a loop in that case, here is an example ...
Choice of a list with a condition in Excel
There are two sheets, in which there is two colums : – from A1 to A3 with dates (example : 01/01/2016), – from B1 to B3 with titles ...
How to get the maximum value in Excel
We have two column, A and B, with towns in A and numbers in B. We would like to determine the maximum value in B, the city with the biggest ...
How to convert a number in time with Excel ?
When we enter a date with points, is there a possibility to convert it automatically into a date with slashes, so that it could be taken into ...
How to add lines with a VBA code in Excel
If you want to automatically add line in your Excel sheet, you can use a VBA code. The following example will add lines after the N column in ...
Excel macro to insert a picture with Redime
You want to save a macro that will allow you to insert a picture (located in a directory of your hard drive disk) in an active cell where you ...
Trading System Forex GadgetVersus GadgetVersus France