I have a large spreadsheet with two columns, “ID”, and “Name”. Is there a function in LibreCalc to tell me which values of ID correspond to more than one unique name?
In SQL, this would be SELECT name, COUNT(DISTINCT name) AS name_count FROM table GROUP BY name HAVING name_count > 1;
, but I’d like to avoid having to setup a SQL database just to perform this check.