Hi. In the past, when I have had large data sets in excel, I have been importing it into access in order to find duplicates, find unmatched and so on. However, of late I have found that microsoft query on excel does pretty much the same sort of thing.
If anyone has any experience of using microsoft query, could you please give me a general overview of how much stuff you can do on it without having to use access. Also, when would you use the Data base functions in excel compared to the normal functions for sum, average etc? Do the database functions do things quicker? I haven't noticed much of a difference but then again my datasets aren't THAT big.
Cheers.
If anyone has any experience of using microsoft query, could you please give me a general overview of how much stuff you can do on it without having to use access. Also, when would you use the Data base functions in excel compared to the normal functions for sum, average etc? Do the database functions do things quicker? I haven't noticed much of a difference but then again my datasets aren't THAT big.
Cheers.