my problem with Example4 is that I am trying to Convert the real formulas to codes, But I failed to achieve this with many formulas.
If you get stuck, this time provide a sample workbook with ALL the columns that have formulas, and only 10-20 rows of sample data and we can look at it again