Is there a function in libreoffice calc 7.4 that finds and shows duplicate line entries as you enter data in lines.
A database can be set up to not store any duplicates values in one column or duplicate combinations in many columns. This way you can rely that there can not be any unwanted duplicates in a database table, therefore you don’t have to detect, highlight and eliminate any.
Ceterum censeo Carthaginem delendam esse. 
2 Likes
Only problem is that I don’t have the Format tab to click on the page. The only tabs I have are: File-Home-Insert-Layout-Data-Review-View-Extension and Tools, but no Format tab.
And where can that database be found?.
You’ve got to roll your own. All the details depend on the exact data you need to store in that database.
In the following database you can’t enter any person twice into the table nor input form. I defined a person as a unique combination of forename, surname and birth date. Names are compared case-insensitively.
DummyPersons_Phones.odb (49.5 KB)
2 Likes
Thanks for your help people, I have finally worked out what to do for my problem, I found the formatting tool in the three bars on the right, click the toolbar, and there she was Formatting, and found the conditional there. Still learning at almost 69 years of age.
1 Like
you may hit by the Birthday_problem if your DataBase growth up to a relevant number of “John Smith” 
Day of birth != Birthday
of course … I blamed me 
sorry for the noise