Calculate Variance Between Grids
Summary:
We have 2 grids. Each grid has exactly the same data but is sourced from different pods. We are using this to determine if any data has changed between the two pods. Our idea is to use a 3rd grid to calculate variances between the first two grids. Is there any ability to write a dynamic formula that we can copy across the rows/columns/cells of the 3rd grid (Similar to what excel would do) that will calculate the variances? Currently it is looking like we need to hard-code each individual cell (and we have 2500 cells).
0