• 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

    pivot table external data sources, multiple csv files Any help appreciated

    I solved the problem with the empty row by adding WHERE column b IS NOT NULL to the SQL query in the data connection. Now I can group dates and bring multiple files in... GREAT :-) Thanks
  2. F

    pivot table external data sources, multiple csv files Any help appreciated

    thanks Hui I will have a look at the .csv files tommorrow... obviously there do have blank rows at the end of the data... but I will look out for anything else... Good to hear that you have done this without blank rows... I will see how i go :-)
  3. F

    pivot table external data sources, multiple csv files Any help appreciated

    Hi all Update Thanks to Hui advice and link and the instructions I can bring in multiple .csv files to my Pivot table... only problem is that there is a blank row between each file (table)...And this is causing problem as I cannot group dates. My problem now is trying to work out how to get...
  4. F

    pivot table external data sources, multiple csv files Any help appreciated

    Hi Hui This looks brilliant!!!! Wow Thanks so much,,, I will try it out and let you know. To get such a quick response and so useful I am so HAPPY :--)
  5. F

    pivot table external data sources, multiple csv files Any help appreciated

    Hi everyone I have been reading and googling and trying and failing :-( This is a bit advanced for me, but I am trying to bring data into a Pivot table from external data sources, namely csv files. I can get it to work for one .csv file but then when i got to do another I have problems I am...
  6. F

    Compare 2 columns highlight duplicates ..

    "copy this to Sheet1 B2 and copy down =+IF(SUMPRODUCT(1*(Sheet1!A2=Sheet2!$A$1:$A$2000))>0,"Duplicate","Unique") Change A$2000 to suit your data range on Sheet 2 " Dear Hui You are so kind this works so well, I am learning so much my head is spinning..
  7. F

    Compare 2 columns highlight duplicates ..

    "Try the following 2 options on Row 2 of page 2 =+IF(MATCH(A2,Sheet1!$A$1:$A$22000)>0,"Duplicate","Unique") or =+IF(SUMPRODUCT(1*(Sheet1!$A$1:$A$6=Sheet2!A2))>0,"Duplicate","Unique") and copy down to the end of the data You can then Copy this column and paste as values and then...
  8. F

    Compare 2 columns highlight duplicates ..

    Thanks Hui, I will try this at work tommorrow, its night here in Australia :-) I am so glad I found this site..
  9. F

    Compare 2 columns highlight duplicates ..

    Hi there I am still learning heaps about excel and have so many projects on the go.. This seems a simple ask but I have spent hours .. I have 2 sheets in a book. I want to compare one column only, and highlight duplicates. there are 22000 rows in one sheet and much less in the other. I wish...
Back
Top