[Solved] Need help with INDEX/MATCH function

Discuss the spreadsheet application

[Solved] Need help with INDEX/MATCH function

Postby Neraphi » Wed Oct 15, 2014 9:59 pm

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:
35mqec2.jpg

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
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

Postby Villeroy » Wed Oct 15, 2014 10:10 pm

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
User avatar
Villeroy
Volunteer
 
Posts: 26981
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Need help with INDEX/MATCH function

Postby Neraphi » Wed Oct 15, 2014 10:36 pm

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

Postby MrProgrammer » Wed Oct 15, 2014 11:34 pm

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
(8.84 KiB) Downloaded 85 times
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3785
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Need help with INDEX/MATCH function

Postby Neraphi » Thu Oct 16, 2014 12:10 am

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


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests