"Barb Reinhardt" wrote:
The problem is that my data is in row 9 or so and beyond.
How would you modify this for that?
Like this, assume source data in A9:B100
In C9:
=IF(B9="","",B9-ROWS($1:1)/10^10)
In D9:
=IF(ROWS($1:1)COUNT($C$9:$C$100),"",
INDEX(A$9:A$100,MATCH(LARGE($C$9:$C$100,ROWS($1:1) ),$C$9:$C$100,0)))
Copy D9 to E9. Select C9:E9, copy down to E100. The autosort will be in
D9:E100, all lines neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---