Hello,
Looking for a way to achieve the above with excel 2010, please refer to the attached excel file. thanks in advance.
Hello,
Looking for a way to achieve the above with excel 2010, please refer to the attached excel file. thanks in advance.
You didn't mention if the dates were relevant, so try:
Please Login or Register to view this content.
Docendo discimus.
Sorry about that , But still I dont see your formula using the date cells that are below the chart ex:31/jul/12, see new attachment highlight in yellow.. thanks
Yes, I saw those dates. You haven't explained how they are to be used.
I need to get the total of changes by support group name + environment + for the yello highlighted date ... Thanks
So, if the yellow highlighted date equals:
- start date?
- end date?
- anything between start date and end date?...
It will be start date = highlighted date.Thanks
In that case, this should work for you:
Let me know how it turns out.Please Login or Register to view this content.
Sorry for the delay in replying, this is exactly what I needed. Thank You!
@ adriandefry
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively 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.
Thanks cutter I will mark solved issues in the future, but I did not forget to click on the STAR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks