First of all check this table…
I want something that will count how many “pencil”, “rubber”, " paper" are here in this sheet. The function will automatically count every sku and write in another column or sheet.
I know a formula COUNTIF()…but in this formula i have to manually put every sku and its not possible Because there are a lot of skus.
So I want a automatic process where the software will automatically recognise all skus and count them.
Is it possible??