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.
All relative I suppose. The initial spreadsheet is 115k lines. Is that large to you? To me its the largest I've dealt with. I crunch it down a lot in various ways. However maybe the method you suggest would add extra benefits in the crunching that I am doing also. However for now I don't have the time to invest is trying it out, just looking for a simpler solution to the grouping.
