 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Count how many ROWS ago a new high was made
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? Guessing a bit of the data cells, but it would be something like =MATCH(MAX(A2:A20),A2:A20,0)  Signature--- HTH Bob (change the xxxx to gmail if mailing direct) >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? I tried that Bob and it was close. I was using =MATCH(MAX(E274:E287),E274:E287,0) The high was made 1 day ago, and the formula returned the number 13 instead of 1. > Guessing a bit of the data cells, but it would be something like > [quoted text clipped - 11 lines] > > 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? Is it ascending data? SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > I tried that Bob and it was close. > I was using =MATCH(MAX(E274:E287),E274:E287,0) [quoted text clipped - 16 lines] > > > 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? What I did was this and it worked. Thanks. =14-MATCH(MAX(E300:E313),E300:E313,0) > Guessing a bit of the data cells, but it would be something like > [quoted text clipped - 11 lines] > > 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?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.