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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top