3 ms·
Spreadsheet is great and dangerous! Try to find duplicates or do vlookup in a table/sheet with more than 10.000 rows. It will only look at the first part of yo
by punnerud 7y ago
Spreadsheet is great and dangerous!
Try to find duplicates or do vlookup in a table/sheet with more than 10.000 rows.
It will only look at the first part of your data, and skip a lot if you don’t remember to sort your columns first.
Yes spreadsheet are a great start. I often ask people to “prototype” in Excel, after that it is SQL that rules.
And remember: Pivot in Excel = ‘Group by’ in SQL
- kgwgk 7y agoI don't know what do you mean by "find duplicates", but VLOOKUP has a option to specify an exact match so you can use it even if the data is not sorted (MATCH does as well).