Tag: Search
-
LibreOffice Calc – Search for Specific Text Across Columns
I have a task I am asked to do fairly regularly that involves searching through a large spreadsheet (around 4,000 rows with about a dozen columns) looking for very specific text. There are, of course, various ways I could accomplish this. But I finally found a solution that speeds this up and want to document…
-
LibreOffice Calc – Comparing and Aligning Two Lists Using VLOOKUP
One of the tasks I have to do regularly as part of my job is to compare two lists to see which items are missing on one list but not the other. I have been doing this by hand but figured there had to be a way to do this in Excel. I finally figured…
-
Linux: Getting “Find” working in Dolphin on KDE (Linux Mint and Kubuntu)
One of the reasons I switched to KDE from Gnome was Dolphin, the file manager that ships with KDE. When I made the switch a couple of years ago, the Find feature in KDE worked really well. But some time in the last couple of years, the two distributions I’ve been using – Kubuntu and…