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

Recent content by sabw

  1. S

    Merge multiple Workbooks without using VBA?

    I have multiple Workbooks with similar file names, identical column headings and identical number of rows. The only other variable (other than file names) is the data in each cell. Each file is named e.g. ba1, ba2, ba3 .... to ba35. Is there any way to combine all of these books into one (1)...
  2. S

    Values remain absolute when Sheet2 re-sorted

    Thanks Narayan
  3. S

    Values remain absolute when Sheet2 re-sorted

    When using formula =Sheet2!C3 in cell C3 of Sheet1, cell reference values stay absolute if Sheet2 is re-sorted producing incorrect values. Is there a formula correction to remedy this? Sheet1 A B C agf aim agf gbd =Sheet2!C3 agf shn agf lku agf ytr agf plm agf ijn...
  4. S

    Replace text between two text references within existing string

    Hi SirJB7 Thanks, regards
  5. S

    Replace text between two text references within existing string

    Can someone provide a formula to produce the Desired text string below. Cell A1: XYZ546 Cell A2: many characters=&symbol=ABC1234&format=tabs 1st reference: symbol= 2nd reference: &format Cell A3 Desired text string: symbol=XYZ546&format The text between symbol and &format varies in length...
  6. S

    Data Validation Named Range

    SirJB7, Thanks for your kind response. I will work with your example & try to incorporate into my requirements. Best regards, sabw
  7. S

    Data Validation Named Range

    Hi Chandoo, Thanks for all your help for this novice. Q. Is it possible to create a drop down box from a named range list that would permit the user to select a value from the first few letters entered and list values would revise as additional letters are entered? e.g. The named range...
  8. S

    How to create a webpage using excel?

    Try https://www.securesheet.com/index.aspx
  9. S

    Histogram to determine the percent of time performance above or below

    https://hotfile.com/dl/183680082/7e9fe3d/Volatility_Simplified_Approach_To_Calculating_Volatility.pdf.html I have tried unsuccessfully to use the Excel 2010 Histogram add-in to create the chart depicted above. The chart is a great way to visualize volatility. Please advise if you can help -...
See more
Back
Top