Right now I am manually adding ranges to the formula I would like to see if it is possible to add into the formula to automatically extend to the last cell without manual input
Column range =COUNTIF(D5:D273, "TRUE")/COUNTA(D5:D273)
Row range =COUNTIF(D5:AM5, "TRUE")/COUNTA(D5:AM5)
Current formula counts all cells in range for "True" Statement compared to all cells within range with any data and makes a percentile of that data to see what the average of passing score is.
I have googled and found OFFSET statements as well as INDEX statement and neither seem to work for what I need these formulas to perform
Having the formula automatically map out to the end of the range will be extremely time saving as I would only need to copy and past and then drag auto fill down the ranges without manually grabbing the end of the row or column.
The values are all text with a "TRUE" or "FALSE"
I have attached a very small sample size, of what it looks like
row 3 started from column E is where formula starts for columns
column D starting in row 3 is where formula starts for rows
The shown picture is how the data is delivered from our script, but instead of 6 machines its 15,000 and instead of 3 tests it is 400.
TRUE
is not the same as"TRUE"
If TRUE is in D5 and you put this formula=TYPE(D5)
into an unused cell, do you get 2 or 4 as a result?