$Intvwg.xlsx
below I have a simple example ... I am trying to find a formula for cell H6 where it will look at the row (mon thru fri) and choose the most recent entry
in this example, the answer would be 34000 --- I am not looking for the MAX ... but rather the most recent entry ... on thursday ... the new answer would be whatever is input into that box ...
thx for all you do!
Try this in H6, came across it accidentally, but, it worked
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Or this...
=INDEX($C$6:$H$6,COUNT($C$6:$H$6))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You are a CHAMPION! I certainly don't know why it works ... but it does!
Thank you!!!
You're welcome
It is looking for a really REALLY big number ....9999999E+307...which it wont find. It will then look for the 1st next-lowest value, which is the 1st non-blank cellOriginally Posted by reglook0736
Thanks for the feedback
Thanks for the info FDibbins
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks