irrelevant

  1. JackDanIce

    Vlookup in VBA generating error

    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...
  2. J

    Returning corresponding cell(s) of those which have the greatest value

    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...
  3. JenniferMurphy

    How to post a workbook with code?

    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...
  4. K

    How to Ignore Year in Date

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top