Hi Gents,
Please help me on that issue as I want to know ( as per attached sample) how to get the date of the next event for a certain name.
Hi Gents,
Please help me on that issue as I want to know ( as per attached sample) how to get the date of the next event for a certain name.
Please explain better what you are trying to achieve; Where did youwant the anwer. Is it based on todays date, tomorrows date or another date?
Pehaps give an example of the anwer of what you are after.
Regards
Peer
If I Need For example to now what is the next RDO date for Mido ( the next one means the one after today's date ), lease check attached sample sheet
Last edited by m2som; 10-19-2013 at 02:18 PM.
Any one to help me please
Hi,
In Q2 and copy down:
=INDEX(B$2:P$2,MATCH(1,(INDEX((B3:P3="RDO")*(B$2:P$2>TODAY()),,)),0))
Regards
Thanks mate, but please can you explain that formula for me?
Gents can you please help me to adjust the formula for this attached file?,, as I need to choose the name
1 way to use the suggested formula is this.
Regards
Fotis.
-This is my Greek whisper to Europe.
--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.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi Fotis1991,
It works as you made it, but can you please explain for me what you have done, Also please if you have other solution with other formula tell me.
I just used the suggestion of XOR LX in hidden column Q.
Then in E10, i used an INDEX&MATCH to get the result.
Formula:Please Login or Register to view this content.
You have any other suggestion, mate?
Sorry, but just for the record, what precisely don't you like about the solution you've been given?
Regards
This ARRAY formula should also works.
Formula:Please Login or Register to view this content.
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
XOR LX
It's ok, I just needed explaination.
Fotis1991
thanks mate.
Or better in E10 and copy down..
Formula:Please Login or Register to view this content.
I believe that is better to use XOR LX suggestion.
So.
You are welcome and thanks for the feed back.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks