I have a table with rows 1 to 1,000 and columns 1 to 1,000 (total active cells 1,000,000)
Each cell is calculated using a complicated algorithm using other variables and both the corresponding row value and corresponding column value, to produce a unique value for each cell. How do I calculate how many of the cells are above a variable value? The result should display, for example, "165,234 cells greater than $2,000", or, "504,719 cells equal to or greater than $1,250".
Solved by E. D. in 17 mins