I am curious what others use to look at patterns of things like numbers and letters? For example, if I wanted to know how many ties a specific number has been entered on a spreadsheet over 1000 rows compared to other numbers out of 100 or how many times a specific number increased or decreased compared to the next number I a spreadsheet. I want t do some comparisons on numbers and letters for example: lets take the number 2, if it has been entered in my spreadsheet 26 times over 1000 rows, I want t know how many times number greater than, less than ad equal too has been entered over the same 1000 rows, also want to know how may of those number were even or odd. How would you all either graph that or table this to look at at a glance to get some good statistics out of it?

I hope this makes sense and thanks for your help