Apache OpenOffice Community Forum

Hello everyone.
Sorry if this has been explained before, but I don't even know how to phrase a search query for this.

For an example of what I'm trying to do: The problem is it returns the same indexed value for 3rd and 4th most sold item.

I'm using this function:
=INDEX($A$2:$A$6;MATCH(LARGE($C$2:$C$6;A9);$C$2:$C$6;0))

I'm looking up the largest "Sold" value in descending order. How would I go about making sure it selects an indexed item that hasn't been displayed before?
It'd be fantastic if someone could explain it or direct me to a forum post or place that does

Thank you in advance.

- Nera

Sort descending by "Sold".

Villeroy wrote:Sort descending by "Sold".

Isn't that what I'm doing? Well, what I'm trying to do. Problem is it displays the same item because it has the same "Sold" value as the previous one.
I might have just misunderstood you, it's getting late... again.

Hi, and welcome to the forum.

Use SUMPRODUCT as explained in my February 2014 post to [Tutorial] Sorting and Filtering data with formulas.

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

MrProgrammer wrote:Hi, and welcome to the forum.

Use SUMPRODUCT as explained in my February 2014 post to [Tutorial] Sorting and Filtering data with formulas.

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

Thank you! That worked great and it's simple enough to remember. I'll give the forum post you linked a read once I wake up.

Thank you again ^^

- Nera