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. tango posted a new thread.

    find and compare data in columns

    I need to find two cells that contains text from three columns... Based on the attached sample, I would like to know the formula on how to...

    Forum: Ask an Excel Question

    Aug 20, 2018 at 12:20 PM
  2. Nightlytic replied to the thread need help to create a macro for pdf printing.

    I hate to be that guy, but your Microsoft already has that functionality. Simply select all the files, right click with mouse and select...

    Aug 20, 2018 at 12:18 PM
  3. Leonardo1234 replied to the thread if column c equal to d then delete that row.

    yes belleke i am doing the same and this code is working also but what i want is mentioned sheet1 name, target sheet1 in ur code so that...

    Aug 20, 2018 at 12:13 PM
  4. Belleke attached a file to the thread if column c equal to d then delete that row.

    Without buttons simply run macro belle in both fil

    Aug 20, 2018 at 12:04 PM
  5. Leonardo1234 replied to the thread keep column b equal to column j data and delete rest data.

    Private Sub CommandButton1_Click() Dim i As Long For i = Cells(Rows.Count, 9).End(xlUp).Row To 2 Step -1 If Cells(i, 2) <>...

    Aug 20, 2018 at 11:40 AM
  6. Leonardo1234 replied to the thread keep column d is greter than column b data and column d is lower than column j data and delete rest.

    Private Sub CommandButton1_Click() Dim i As Long For i = Cells(Rows.Count, 4).End(xlUp).Row To 2 Step -1 If Cells(i, 4) <=...

    Aug 20, 2018 at 11:39 AM
  7. Leonardo1234 replied to the thread keep column b equal to column j data and delete rest data.

    Private Sub CommandButton1_Click() Dim i As Long For i = Cells(Rows.Count, 9).End(xlUp).Row To 2 Step -1 If Cells(i, 2) <>...

    Aug 20, 2018 at 11:39 AM
  8. Leonardo1234 replied to the thread Conditional copy and paste.

    Private Sub CommandButton1_Click() Dim i As Long For i = Cells(Rows.Count, 9).End(xlUp).Row To 2 Step -1 If Cells(i, 9) =...

    Aug 20, 2018 at 11:37 AM
  9. Leonardo1234 replied to the thread copy and paste the data from two files into one files.

    Thnx Belleke for giving ur precious time and great support to this post Problem Solved

    Aug 20, 2018 at 11:35 AM
  10. Leonardo1234 replied to the thread if column c equal to d then delete that row.

    Private Sub CommandButton1_Click() Dim cell As Range For Each cell In ActiveSheet.UsedRange.Columns(3).Cells If cell.Value =...

    Aug 20, 2018 at 11:34 AM
  11. Leonardo1234 replied to the thread keep column b equal to column j data and delete rest data.

    Thnx Belleke for giving ur precious time and great support to this post Problem solved

    Aug 20, 2018 at 11:12 AM
  12. Leonardo1234 liked Belleke's post in the thread keep column b equal to column j data and delete rest data.

    My mistake:oops: Version 2

    Aug 20, 2018 at 11:11 AM
  13. Belleke attached a file to the thread keep column b equal to column j data and delete rest data.

    My mistake:oops: Version 2

    Aug 20, 2018 at 11:04 AM
  14. Manish Kumawat posted a new thread.

    Sumifs and Countifs Formula

    Hi guys, I need some help in understanding the sumifs and countifs formulas. Please find attached the file where i have applied both the...

    Forum: Ask an Excel Question

    Aug 20, 2018 at 11:03 AM
  15. Belleke attached a file to the thread copy and paste the data from two files into one files.

    Version number 2

    Aug 20, 2018 at 10:54 AM
Loading...