I'm trying to condense following:
Select Case i
Case 1 To 3: ForeCastCol = "A"
Case 4 To 10: ForeCastCol = "B"
Case 11 To 15: ForeCastCol = "C"
Case Else: ForeCastCol = "D" 'Limit is 18 regardless
Hi everyone. Long time lurker, first time poster, this site and the users have provided me with great knowledge over the past few years, so thank you to everyone.
I'm getting a bit deeper than I have needed in the past and need a little assistance b/c I could not find what I was looking for...
I have written a Sub that I would like to post with some questions. I also have a workbook that calls that Sub to demonstrate how it works and illustrate the questions.
Since attachments are not allowed, I would upload it to Dropbox and post the link. But what's the best way to do that?
Hi all first of many posts to come here :) . I am trying to write a formula that looks at between dates but ignores the year. For example, if a birthday is between the first of January and the thirteenth of February, the year is irrelevant as it can be any year. Bearing in mind dates of birth...