right , its mostly for indicators. The function calculates the highest correlation by using different time periods. For example the Average Hours per Week is a "leading" indicator for future Employment numbers and the lead is three month. I need the formula in Excel that calculates the lead (three month). I used to have it in spreadsheet , but lost it
