I have an Excel sheet with a huge amount of different number combinations. Now I was wondering if it would be possible to indicate how many times a certain number occurs (if I search how many times the number '1' occurs, I don't want Excel to count the number '11') and to show what number combinations occur the most. All the combinations I have at the moment are unique, but I want to check how many times a combination of for example the same first three numbers occurs. I have no idea if this is remotely possible in Excel. Attached is a screenshot to clarify what I'm trying to ask. Thanks in advance for your answers.
Bookmarks