## [Solved] Need help with INDEX/MATCH function

### [Solved] Need help with INDEX/MATCH function

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

- Nera
Last edited by Neraphi on Thu Oct 16, 2014 12:08 am, edited 1 time in total.
OpenOffice 4.0.1 on Windows 7
Neraphi

Posts: 3
Joined: Wed Oct 15, 2014 9:34 pm

### Re: Need help with INDEX/MATCH function

Sort descending by "Sold".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x

Villeroy
Volunteer

Posts: 27601
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Need help with INDEX/MATCH function

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.
OpenOffice 4.0.1 on Windows 7
Neraphi

Posts: 3
Joined: Wed Oct 15, 2014 9:34 pm

### Re: Need help with INDEX/MATCH function

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.
Attachments
201410151630.ods
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).

MrProgrammer
Moderator

Posts: 3944
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

### Re: Need help with INDEX/MATCH function

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
OpenOffice 4.0.1 on Windows 7
Neraphi

Posts: 3
Joined: Wed Oct 15, 2014 9:34 pm