excel rows,find if include,low and high
Posted
by
Malin Pedersen
on Super User
See other posts from Super User
or by Malin Pedersen
Published on 2013-10-20T16:05:12Z
Indexed on
2013/10/20
21:58 UTC
Read the original article
Hit count: 347
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?
© Super User or respective owner
