Count how many ROWS ago a new high was made

Giganews Newsgroups
Subject: Count how many ROWS ago a new high was made
Posted by:  rhhince (rhhin…@shaw.ca)
Date: 13 Jan 2007

I need to count how many rows ago a new high was made in the last 6
days. In this case 2 days ago a new high was made. How to I get excel
to count that number of rows ago without manually doing this?

Replies