COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made

R

rhhince

I need to count how many rows ago out of 10 days that the highest high
in 10 days was made. Let's say the highest high was made 4 days ago, I
need a formula to come up with 4 as the answer. If it is new high, I
need 0 as the answer, because it is a new start.
 
G

Guest

Please post your details or response to others suggestion in the same thread.
You have 4 threads on this same topic. If you keep jumping around, it is
difficult for others to help. Also, FYI - I usually ignore posters who
multipost because it wastes the time of those who are attempting to assist
(because the necessary details are spread out among multiple threads or the
question has already been answered in another thread).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting how many rows since a new value was made 1
Count how many ROWS ago a new high was made 4
Count the highest number of days without “errors” 2
How do I not count cells that have formulas in them 2
Count how many Rows ago a particular number was hit 1
Number of days 2
adding days correctly 4
Manadatory break after 10 days of work formulae 2

Top