sir,
I want to count the number of cells with higher high /lower lows in a row in excel and to compute the value change between the high and higher high (or low and lower low) cells.
I enclose a model excel sheet with question and desired answer sheets for perusal please
regards,
With thanks
vks1964