Have I been sleeping on data validation lists, or was always just ignorant.

[awoohaw]

I noticed today that I selected a column of 25 cells with only 3 unique names to use as a data validation list. when i clicked on the drop down the list was already filtered. Is this a fairly recent addition, or have I always misunderstood it? I have 365.

 

[awoohaw]

I found it. It was rolled out with the May 2022, Current Version Preview to Microsoft Insiders.

Release Notes Current Channel (Preview) - Office release notes

Provide Insider Slow audience with the latest list of new features, fixes or known issues

learn.microsoft.com

 

[MARK858]

(I wonder what 'current channel preview" means, though).

 

[awoohaw]

Thanks @MARK858 , but if this was in preview in May 2022 why is it not in all 365 by now?

I don't know if you did the highlight above or not, but I am in the next group down, Monthly Channel (Targeted).

 

[Sufiyan97]

Okay, but you can check your version on your excel "account" page:
(So, I now have 2303) (I wonder what 'current channel preview" means, though).

it is

 

[MARK858]

Thanks @MARK858 , but if this was in preview in May 2022 why is it not in all 365 by now?

Gets released when they are happy with it after following up on feedback

 

[awoohaw]

it is

View attachment 87543

@Sufiyan97 , you have the Version at the top of Mark858's post. And the update you have is Feb 2023. So, I'm thinking you would not have this data validation update.

 

[awoohaw]

Gets released when they are happy with it after following up on feedback

I read it to be mean that this is the channel of what is coming next month. But, your comment makes sense in light of the current situation. Maybe I'll give them some feedback! It is a time saver!

 

[MARK858]

I read it to be mean that this is the channel of what is coming next month. But, your comment makes sense in light of the current situation. Maybe I'll give them some feedback! It is a time saver!

Any of the versions that are classed as "Insider" are at various stages of testing and so if someone raises an issue late in the process that is of concern then they will put the general release on hold until they are satisfied it is ready for general release (and even then it is a gradual rollout, also the 32bit version is normally updated before the 64bit version)

 

[awoohaw]

Hey forum members.... I'm circling back on this. Does anyone know if the full release version of 365 has the automatic de-duplication in data validation lists? I am on on Current Channel(Preview) so I am not really sure if it is available to everyone. And do any of you on Current Channel not have it?

 

[RoryA]

According to the features flyer in the Excel blog, as long as you have version 2306 or later on CC, you will have it.