How to have combo list sorted

A

AA Arens

I have set the following data name:
=OFFSET(Par!$D$2,0,0,COUNTA(Par!$D$2:$D$201)-COUNTBLANK(Par!$D$2:$D$201),1)

How to get all data in the right onummeric order?

It seems to be with offset($D$2,0,0,counta($D:$201),1).... likely looks
like the upperformula I use.

But the combo is not sorted when I use it.

Bart
 
T

T. Valko

You would have to sort the source data:

Whatever's in this range Par!$D$2:$D$201 needs to be sorted.

Biff
 
A

AA Arens

The row left of it is created by:

=IF(Solo!C22="","",Solo!C22)
=IF(Solo!C22="","",Solo!C22)
etc.

How to have this column permanantly order nummeric?

Bart
 
T

T. Valko

If I understand.......

To sort ascending:

=IF(ROWS($1:1)<=COUNT(Solo!C$2:C$201),SMALL(Solo!C$2:C$201,ROWS($1:1)),"")

To sort descending, replace SMALL with LARGE.

Biff
 
A

AA Arens

Thanks, that does the job.

Bart
Jakarta.

If I understand.......

To sort ascending:

=IF(ROWS($1:1)<=COUNT(Solo!C$2:C$201),SMALL(Solo!C$2:C$201,ROWS($1:1)),"")

To sort descending, replace SMALL with LARGE.

Biff
Click to expand...
 
Top