Sorting with formulas

G

GreenAce

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!
 
M

Max

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.
 
G

GreenAce

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

Thanks for your help!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top