Please see attached MaxDateTest.xls
The sheet has two named ranges:
=> Friday -- a list of dates (Fridays) from 1-Jan-2010 thru 25-Jun-2010
=> Widgets -- the count of widgets for each Friday from 1-Jan-2010 to 5-Mar-2010. Counts after that are all #NA
I already learned how to find the largest number of widgets in the Widgets range (92 widgets), .
Now I want to learn how to get the Friday associated with those 92 widgets (should be 5-Feb-2010).
I will be grately deepful if you can give me the formula for doing that.
Last edited by Carrfamily; 02-09-2012 at 04:04 PM.
Hi
See the attached
Regards
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi Carrfamily,
Use following formula :-
Regards,=OFFSET($A$1,MATCH($E$5,Widgits,0),0)
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Hi
Try this.
=INDEX(Friday;MATCH(E5;Widgits;0))
Change the semi-colons to gomma, if you have to do.
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thanks a trillion, Mahju! That's so elegant. The formula I had been concocting was hundreds of characters long and still metastasizing, to no avail. Would have given Einstein a migraine. Thanks again!
You are wellcome
Please mark the thread as solved
See my signature
Regards
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks