1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent Activity

Activity stream for all registered members at Chandoo.org Excel Forums - Become Awesome in Excel.

  1. Thomas Kuriakose liked NARAYANK991's post in the thread Matching Stock from Booking.

    Hi , See if this is what you wanted. Narayan

    Sep 23, 2017 at 6:18 AM
  2. Thomas Kuriakose liked Hui's post in the thread Convert text to numbers into multiple columns.

    in a Blank cell type 1 Then copy that cell Select the whole Column/s with the numbers Goto Home, Paste, Paste Special, Select Values,...

    Sep 23, 2017 at 6:12 AM
  3. Thomas Kuriakose liked Naresh Yadav's post in the thread Calculate YTD sales with dynamic weeks.

    Hi, Pls check if it works for you regards Naresh

    Sep 23, 2017 at 6:11 AM
  4. Thomas Kuriakose liked NARAYANK991's post in the thread Adding New Worksheet.

    Hi , Because I had mentioned that the code should be placed in the ThisWorkbook section , the keyword Me refers to the Workbook where this...

    Sep 23, 2017 at 6:10 AM
  5. Thomas Kuriakose liked NARAYANK991's post in the thread Adding New Worksheet.

    Hi , Try the following code in the ThisWorkbook section of your file : Public Sub AddSheets() Const SHEETCOUNT = 6...

    Sep 23, 2017 at 6:10 AM
  6. Thomas Kuriakose liked bosco_yip's post in the thread Help : Multiple Match & Index.

    1] A2, copied down : =IFERROR(INDEX(Sheet1!A$2:A$10,MATCH(0,INDEX(COUNTIF(A$1:A1,Sheet1!A$2:A$10),0),0)),"") 2] B2, copied across and all...

    Sep 23, 2017 at 6:08 AM
  7. Winston618 replied to the thread Loop runs but produce partial result.

    One following up question, if I want to set the range F2:F500 to a dynamic range, how can I do it?

    Sep 23, 2017 at 6:08 AM
  8. Thomas Kuriakose liked bosco_yip's post in the thread Automatic repeating sequence.

    F4, copied down : ="M-"&101+INT((ROW(A1)-1)/C$3)&CHAR(65+MOD(ROW(A1)-1,C$3)) Regards Bosco

    Sep 23, 2017 at 6:08 AM
  9. Thomas Kuriakose liked Hui's post in the thread Adding In-Cell comments to a chart.

    There is no easy way You can use a User Defined Function to extract the Comments to an Adjacent Cell Then link the Chart's Data Labels to...

    Sep 23, 2017 at 6:07 AM
  10. NARAYANK991 replied to the thread UserForm not adding data to table appropriately.

    Hi , In your AddRow procedure , you are using the following line of code to find out the last row which is non-blank : Range("A" &...

    Sep 23, 2017 at 5:03 AM
  11. Logit replied to the thread UserForm not adding data to table appropriately.

    This is all you need to write data from the UserForm to a worksheet : Private Sub btnOK_Click() Dim ws As Worksheet Set ws =...

    Sep 23, 2017 at 4:26 AM
  12. Hui replied to the thread Adding In-Cell comments to a chart.

    There is no easy way You can use a User Defined Function to extract the Comments to an Adjacent Cell Then link the Chart's Data Labels to...

    Sep 23, 2017 at 3:45 AM
  13. Winston618 replied to the thread Loop runs but produce partial result.

    Thank you for pointing out the problem behind my logic, I got it now.

    Sep 23, 2017 at 2:58 AM
  14. bosco_yip replied to the thread Automatic repeating sequence.

    F4, copied down : ="M-"&101+INT((ROW(A1)-1)/C$3)&CHAR(65+MOD(ROW(A1)-1,C$3)) Regards Bosco

    Sep 23, 2017 at 12:41 AM
  15. sheter posted a new thread.

    Automatic repeating sequence

    I'm trying to automate my sheet numbers at the beginning of a project. Sometimes the building is so big we have to break it up into...

    Forum: Ask an Excel Question

    Sep 22, 2017 at 10:32 PM
Loading...