Need some Excel Spreadsheet help

Pivot table

Count on column A

I would do pivot. Insert on the ribbon, select all the numbers in column a as your data

Row value will be the number (1-189)
The data value will be count of values

Someone beat me to it. Do a subtotal with a count would be another way

as the others say, a pivot table is what you want. not sure you will be able to figure it out at this time of night, without any real help though.

thanks guys. Exactly what I needed

Pivot table is answer

If you can figure that out but the number 1 next to all numbers in column b and subtotal

To insert a pivot table


It will bring up this to select data set:

Select all of your data (click in a1, then hold ctrl+shift+down to highlight all cells)
OK


You can give column a a title or it will say data or something. Click in the right section on it and drag into bottom left and bottom right. It will make bottom right sum. Left click on it and select pivot table options, make it a count formula.

If moving to another sheet/workbook copy and paste values, not the table. You can use format painter to make it look nice

I recommend counting it manually.

Or... just dump it into a sql server and select distinct with count.

SELECT DISTINCT (column), COUNT (column) AS Total
FROM yourexcelfile
GROUP BY (column), COUNT (column)

Upload that shite to the cloud and hammer out a uSQL statement

Just joking. Nice tutorial. I hate excel.

The boring shite we do for money. What a time to be alive.

quote:

---

this is a very easy task tbh

---

My baw is a baller now. Lynx laughs at these simple tasks now