I work with lists of data that have thousands of data entries in the list. I need to be able to group all of the similar data together and then generate a count for each group. The problem that I'm having is that some of the data is slightly different from each other, but I still want it to be in the same category. For example, this is what my list might look like.
Dog
Dogs
White dog
Cat
cat
cats
All of that data is slightly different from each other, yet you can still tell that all the top data should go into one category together for dogs, and all the bottom data should go into another category for cats. Is there any way to have a formula to get this type of data grouped together and then counted? Thanks for your help!
Dog
Dogs
White dog
Cat
cat
cats
All of that data is slightly different from each other, yet you can still tell that all the top data should go into one category together for dogs, and all the bottom data should go into another category for cats. Is there any way to have a formula to get this type of data grouped together and then counted? Thanks for your help!