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.
I 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).
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