Identify lowest 5 sequential rows byVarSuppose I have a table of RunNumber (1,2,3...) and Result (numeric/continuous).
How can I create a formula column that identifies (e.g. with a "1") the sequence of 5 numbers with the lowest average value for each RunNumber and a "0" everywhere else?
Data Blending and Cleanup
