• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I want macro

A

Abhijeet

Active Member
Hi
I have data with days of the month & as per assignment number I want from which date S Or AL mention that start date & end date of that code I want But in Saturday & sunday nothing is mention then if Monday same code in Friday is their then consider Mondays last date.
Is sample file I mention what data I want
 

Attachments

  • Date.xlsx
    10.9 KB · Views: 18
Hi, Abhijeet!

Are you very hurried? If so please take a break and dedicate 5 minutes to what follows. Posting without adding any useful information just for bumping up a topic doesn't guarantee neither a faster assistance nor getting the interest of people who might be reading that post, but rather the opposite effect of discouraging them.

If you'd have read the 1st forum at the main page...
http://chandoo.org/forum/forums/new-users-please-start-here.14/
...you should have noticed this points (and if you did it seems as if you should do it again):

"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."

"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."

"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."

"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question for free. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."

Regards!

PS: If it's a high priority issue and you can't even wait... how much?... oh, 11 hours and a while... absolutely unbearable... but you always have the alternative of hiring a local consultant who may provide you the exact tailored service. Should I remember you that these forums are supported by contributors who dedicate part of their time in an absolutely free way to help other people and answer questions?
 
Hi, Abhijeet!
Please explain why to you want that output for code 1234 (all S together) and not for codes 1235 and 13456-2 (neither all S nor AL together). Thank you.
Regards!
 
Hi, Abhijeet!

Sorry but I don't seem to be of further help as I don't understand the criteria you use for grouping the value for each parameter according to the date ranges, and you're not helpful at all.

For 1234, 1 criteria S, Dec 2/Dec 10 (where days 7 & 8 are empty)
For 1235, 2 criteria S, Dec 1/Dec 2 and Dec 6/Dec 31 (where days, 3,4,5,7,8, 14, 15, 20, 21, 28 & 29 are empty)
For 13456-2, 1 criteria S, Dec 1/Dec 2, 2 criteria AL, Dec 3/Dec 4 and Dec 6/Dec 6, 1 criteria S, Dec 10/Dec 11 (with no empty cells)

Regards!
 
Hi, Abhijeet!
I apologize but even I make may best efforts I'm unable to understand your explanations. Wish you that somebody else could interpret your requirements. Good luck.
Regards!
 
Abhijeet,

If you can’t explain it simply, you don’t understand it well enough … (Albert Einstein)​
 
You must log in or register to reply here.
Back
Top