Hi,
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
End Select
To:Application.Vlookup(i, [3...
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?
I...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.