Ask Me Help Desk - count the number of cells with higher high /lower lows and change in value

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)

- Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)

- - count the number of cells with higher high /lower lows and change in value (https://www.askmehelpdesk.com/showthread.php?t=850690)

1 Attachment(s)

count the number of cells with higher high /lower lows and change in value

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

All times are GMT -7. The time now is 01:57 PM.