You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!