How to have combo list sorted

[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. Valko]

You would have to sort the source data:

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

Biff

 

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

 

[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

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thanks, that does the job.

Bart
Jakarta.