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

Search results

  1. F

    Splitting Alpha Numeric characters in Cell reference

    Hello Guys Looking for help: I am trying to split the characters to cell references so that I can separate out just the row number. e.g A12 - to - A & 12 AB12- to - AB & 12 AB143 - to - AB & 143 The number of the alpha characters & the Numeric characters can differ so cannot use...
  2. F

    Sorting Validation Lists

    Brilliant guys, it works beautifully. Thanks to both and our hero...
  3. F

    Sorting Validation Lists

    Hi Indian. Sorry, where do i enter this formula. Is this in place of the Validation formula? Also what does SMALL refer to?
  4. F

    Sorting Validation Lists

    Hi Guys I have created dynamic a list with Resource names that I am using in a Validation formula. The list has to be in a specific order- (grouped), hence the names are not in alphabetical order in the original list. When they appear in the Drp-Down list they are not in alphabetical order...
  5. F

    Macros in 2007 Running in 2010

    I created a macro in Excel 2007 but when my colleagure tries to open it in Excel 2010, it brings about a message "VBA macro in this workbook have been currupted..." Anyone know how I can fix this. Many Thanks in adavnce.
Back
Top