Sorting a group of data from ascending to descending

**11linc11** · 01-19-2013, 08:31 PM

Hi all,

I’m having trouble getting the =match function to return a greater than value. Turns out I need my data set to be sorted in descending order. So I need to swap my data set around.

My data can be changed at any time by an "in use" selection, when not "in use" the data can go to a dummy value depending on what is required. I've found this dummy value to be annoying when trying to collate max and then using match +1 to return the cell above. I could simply go a1 = a99 and a2 = a98 but I have just under 100 cells and this would take time. How can I get this done using excel?

Delay In Use In Use Delay
25 Y 25
50 N
75 Y 75
100 Y 100
125 Y 125
150 Y 150
175 N
200 Y 200
250 Y 250

Thanks in advance for the help.

Linc
Forum Data.xlsx

**oeldere** · 01-19-2013, 08:35 PM

If i sort Z to A I get this result.

Excel 2007 => data => sort Z to A.

You need to select the whole range (including the headers).

See the attached file.

**FDibbins** · 01-19-2013, 08:41 PM

This may be applied to the wrong column, but the principle is sound. In E6, copied down, use this...

=LARGE($B$6:$B$14,ROW(A1))

Adjust references as needed

**11linc11** · 01-19-2013, 09:51 PM

Thanks for the replies,

Oeldere, I should have clarrified that I was hoping that this data didn't have to be managed and that data in column B and D are not meant to be edited. Appoligies about not being clear enough.

FDibbins, This has worked for the most part so thank you for that.

**FDibbins** · 01-19-2013, 09:53 PM

for the most part? what part isnt working, and what would your expected outcome be?

**11linc11** · 01-19-2013, 10:00 PM

Haha, as in that step has worked which has put me 1 step closer to solving a greater problem im having... This could be another dead end though so that is the "most part section".

**oeldere** · 01-20-2013, 05:00 AM

Thanks for the reply.

Glad I could help.

If the question is solved, will you mark your question as solved?

If you have (other) questions or comments , on this item, just ask or comment.