Alphabetical ranking in data validation list

[Villalobos]

Hello,

I would like to ask that how should do the alphabetical ranking in the data validation list?
I have attached the sample file to this thread.

Many thanks the response!

 

[Somendra Misra]

Hi,

What do you mean by ranking? Do you mean sorting?

Regards,

 

[Villalobos]

Hello Somendra Misra,

I would like to see the fruits from A to Z in the data validation list.

 

[Somendra Misra]

Sort column A.

Regards,

 

[Villalobos]

This was my first idea also but unfortunately this is not allowed option. This is reason why a bit tricky for me.

 

[Somendra Misra]

What do you mean by not allowed option.

I can do it in your file.

Regards,

 

[udprocks]

[/quote]

This was my first idea also but unfortunately this is not allowed option. This is reason why a bit tricky for me.

Yes somendra sir is correct,

see the file.

 

[Villalobos]

What do you mean by not allowed option.

I can do it in your file.

Regards,

This is a basic criteria of this role, nothing more. The structure of data (in column A) is locked for the modification.

 

[Somendra Misra]

Hi If you had locked it, you can unlock it and select Sort option from protect sheet option.

If you cannot unlock it than tell we will try some formula solution for this.

Regards,

 

[Villalobos]

The unlocking is not possible.

 

[Somendra Misra]

Wait for some minutes, will get back.

Regards,

 

[Somendra Misra]

Will your list contains Duplicates, because your sample file contains.

Regards,

 

[Villalobos]

Ok, yes there are 3 duplicated item.

 

[Somendra Misra]

So in your actual file, will there be duplicates?

Regards,

 

[Villalobos]

No need duplicates.

 

[Somendra Misra]

See the file, it uses 2 named formula and 1 helper column N.

Regards,

 

[Villalobos]

Thanks, you are great!

 

[Somendra Misra]

Thanks for the feedback, you are Welcome.

Regards,