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.
 
J

JMB

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 the highest number of days without “errors” 2
WORD VBA Search and switch to advanced ... 1
A couple questions BEFORE using Office 365 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Count how many ROWS ago a new high was made 4
How do I not count cells that have formulas in them 2
Triggering a Flag after 10 days that excludes weekends and holiday 3

Top