I am looking for how to make a cell in excel that tells me how many of a certain item I have. In column b I have values (numerical) of certain items corresponding to column c next to it ie...
what I want is a cell that I can have list output like this:
input output (this is where I need help)
tried using search() but that returns an array and tried using row() but first I would need to know the cell location of a found string