Sorting with formulas
 

I see pieces of formulas that solve what I'm looking for, but can't get it
all to work together. I have a list of scores that I'll continue to add to
that I need to sort with a formula from lowest to highest. I want to keep
duplicate entries but don't want to show blank entries. Here's an example:
Row ColA ColB (sorted)
1 42 36
2 42 38
3 36 40
4 42
5 40 42
6 42 42
7 48
8 48
9 38
10 fill in 10-25 later
.....
25

I'm a beginner with these more complex formulas, so I really appreciate you
saving me the frustration.
Thanks!

Sorting with formulas
 

Try this in B1 and drag down

=SMALL($A$1:$A$25,ROW(A1))

Mike

"GreenAce" wrote:

I see pieces of formulas that solve what I'm looking for, but can't get it
all to work together. I have a list of scores that I'll continue to add to
that I need to sort with a formula from lowest to highest. I want to keep
duplicate entries but don't want to show blank entries. Here's an example:
Row ColA ColB (sorted)
1 42 36
2 42 38
3 36 40
4 42
5 40 42
6 42 42
7 48
8 48
9 38
10 fill in 10-25 later
....
25

I'm a beginner with these more complex formulas, so I really appreciate you
saving me the frustration.
Thanks!

Sorting with formulas
 

One play which should deliver the goods ..
Source data in A1 down, with interspersed blanks & duplicates
In B1:
=IF(A1="","",A1+ROW()/10^10)
In C1:
=IF(ROW()COUNT(B:B),"",INDEX(A:A,MATCH(SMALL(B:B, ROW()),B:B,0)))
Select B1:C1, copy down to cover the max expected extent of data in col A,
eg down to C500? Minimize/hide away col B. Col C will return the required
auto-sorted results, w/o blank lines.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GreenAce" wrote:
I see pieces of formulas that solve what I'm looking for, but can't get it
all to work together. I have a list of scores that I'll continue to add to
that I need to sort with a formula from lowest to highest. I want to keep
duplicate entries but don't want to show blank entries. Here's an example:
Row ColA ColB (sorted)
1 42 36
2 42 38
3 36 40
4 42
5 40 42
6 42 42
7 48
8 48
9 38
10 fill in 10-25 later
....
25

I'm a beginner with these more complex formulas, so I really appreciate you
saving me the frustration.
Thanks!

Sorting with formulas
 

I thought I would need to use an array, but this is much simpler and it worked.

Thanks for your help!!

"Mike H" wrote:

Try this in B1 and drag down

=SMALL($A$1:$A$25,ROW(A1))

Mike

"GreenAce" wrote:

I see pieces of formulas that solve what I'm looking for, but can't get it
all to work together. I have a list of scores that I'll continue to add to
that I need to sort with a formula from lowest to highest. I want to keep
duplicate entries but don't want to show blank entries. Here's an example:
Row ColA ColB (sorted)
1 42 36
2 42 38
3 36 40
4 42
5 40 42
6 42 42
7 48
8 48
9 38
10 fill in 10-25 later
....
25

I'm a beginner with these more complex formulas, so I really appreciate you
saving me the frustration.
Thanks!