Forum Discussion
Group rows based on similar text
I have a very large spreadsheet with one column that start with similar text but pretty much every line is slightly different. Below is a rough idea on what I mean (image two columns): ID Softw...
lfk73 The three words in your post "very large spreadsheet" would warrant to look into Power Query as a variant to the formula based solution with sub-totals as suggested by HansVogelaar
But since your example give only a "rough idea" of your real data, I might be wrong.