excel rows,find if include,low and high
- by Malin Pedersen
Link to full-size image
For what is marked in orange:
As mentioned in the example in the picture it says "headphones". I would like it to search through all the lines in column A, to find something that has that name in it, then it should count the number of people, and come out with the number (in how many)
the "middle price" I want it to take the price of B (depending on where it found it called headphones) and take the average price of it.
In secured, as I would like it to count how many of them (from the number, or from the beginning) that have "secured" as "no" and "yes."
I would like to use this on several things.
For what is marked in pink:
Where would I find the average price of all the goods, and what the name of the particular item is? Same with the highest and lowest price.
How can I do this?