Accending order
 

Hi,

Formula =IF(COUNTIF(O$7:O8,O8)=1,MAX(N$7:N7)+1,"") is counting the
row index.

This formula is making a list of unique items which I am further using
in a data validation list.
=IF(MAX(NCOUNT)<ROW(1:1),"",VLOOKUP(ROW(1:1),NLIST ,2))

The list is like

550
551
552
553
554
C-09
C-10
555
556
557
C-11

I want to have this validation list in accending order like

C-09
C-10
C-11
550
551
552
553
554
555
556
557

Thx.

Accending order
 

You can just sort your list - the "C" entries will come after the 5's. As to
the reference ROW(1:1) in your second formula, ROW(1:1) returns a numeric 1.
Why not just use 1? Secondly looking up a 1 in your list doesn't make sense
(VLOOKUP(1,NLIST,2) and thirdly the vlookup is to return column 2 of the
list after an approximate match. I see only 1 column in the list. I have a
feeling this is not doing what you think it is. Just what are you trying to
accomplish?

Tyro

"Sinner" wrote in message
...

Hi,

Formula =IF(COUNTIF(O$7:O8,O8)=1,MAX(N$7:N7)+1,"") is counting the
row index.

This formula is making a list of unique items which I am further using
in a data validation list.
=IF(MAX(NCOUNT)<ROW(1:1),"",VLOOKUP(ROW(1:1),NLIST ,2))

The list is like

550
551
552
553
554
C-09
C-10
555
556
557
C-11

I want to have this validation list in accending order like

C-09
C-10
C-11
550
551
552
553
554
555
556
557

Thx.