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
[Solved] Need help with INDEX/MATCH function
[Solved] Need help with INDEX/MATCH function
Last edited by Neraphi on Thu Oct 16, 2014 12:08 am, edited 1 time in total.
OpenOffice 4.0.1 on Windows 7
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Need help with INDEX/MATCH function
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.Villeroy wrote:Sort descending by "Sold".
I might have just misunderstood you, it's getting late... again.
OpenOffice 4.0.1 on Windows 7
- MrProgrammer
- Moderator
- Posts: 4906
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
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.
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 166 times
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: Need help with INDEX/MATCH function
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.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 again ^^
- Nera
OpenOffice 4.0.1 on Windows 7