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
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 :-)
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...
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
:--)
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...
"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..
"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...
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...