Sort numbers & drag across corresponding column text

Hi Guys,

I've stumped myself and would really appreciate any help you could provide me.

I'm trying to find a formula which will sort my numbers in descending order, but also bring across the appropriate text corresponding to that number. This needs to be a formula because I need to use it in multiple sheets so it updates when new data is dumped in.

In the attachment I have my data in column C and D. And in column F and G it has the result i'm looking for.

I have tried a formula which contains Index, Match and Count If but i can't seem to get it to work. Hopefully you can help!

Cheers
Rooboyz

hi rooboyz,

have first row of that c and d column any heaters like (name, qty)

then click at any where in the c and d clumn and go to the data tap and select the filter option, then you will get the filter option in the first column.
go to the d colum filter option click sort largest to smallest, then you get the result.


find the attached file...

thanks and regards,

sathya

OK so there are 2 parts to this: Sorting and Matching, so first I did the Sort in a column, then the Match
1. Sort this formula works: =IFERROR(LARGE($D$1:$D$15,ROW()),0)
2. Match ... here I have a problem with the duplicates but I used; =INDEX($C$1:$C$15,MATCH(J1,$D$1:$D$15,0)) but the duplicate "0" gave me an issue that maybe you or someone else can solve...

Cheers

So I found away around it but it requires an extra formula in col C so have a look at this:

LARGE AND SORT.xlsx

Originally Posted by Ursul

So I found away around it but it requires an extra formula in col C so have a look at this:

Attachment 271319

That's perfect thank you!

I was having a heap of issues trying to get it to work over two columns and also handle the duplicates. But that extra column makes a huge difference. Thanks again!

Originally Posted by sathiyamoorthy

hi rooboyz,

have first row of that c and d column any heaters like (name, qty)

then click at any where in the c and d clumn and go to the data tap and select the filter option, then you will get the filter option in the first column.
go to the d colum filter option click sort largest to smallest, then you get the result.


find the attached file...

thanks and regards,

sathya

Thanks for taking a look!

Thanks Sathya, I appreciate the feedback and you are most welcome.

Pleased to help a fellow Aussie!

Please mark this Thread as "SOLVED" and if you don't mind click the little "add Reputation" at the bottom left of this post.