Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
This is kind of complex I think, but I'm hoping someone might have an easy solution. I need to sort two columns for match parings, but the second column needs to match as closely to the nearest value of the grouping ahead of it. In other words, I need the sort to reverse itself after each whole number break in the first column. Here is an example:
Raw data Score Comp 20 5 20 9 20 0 19 12 19 4 19 3 19 1 18 8 18 7 18 7 How I want it to come out: Score Comp 20 9 20 5 20 0 19 1 19 3 19 4 19 12 18 8 18 7 18 7 The problem is simply doing a double sort gets this: 20 9 20 5 20 0 19 12 19 4 19 3 19 1 18 8 18 7 18 7 Any suggestions? Thank you all very much for your help. David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match formula to match values in multiple columns | Excel Discussion (Misc queries) | |||
Match formula to match values in multiple columns | Excel Programming | |||
Sort by Large, Offset from Match, Duplicate values problem | Excel Discussion (Misc queries) | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
How do I match identical values in 2 columns and then sort? | Excel Discussion (Misc queries) |