Data validation without duplicates - Excel Tricks

#ExcelDropDownBox #DataValidationExcel

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, Excel has the right tools to do it. In-cell drop-down lists or combo boxes can assist you in picking up a value from a valid list to enter in a cell. But what if you want to set up data validation list without duplicates?

For example workbook and more tips on Data Validation dropdown boxes, visit
=========================================

[manojpai]

I simply love the manner in which you explain things..You are Excel God!!!

[mymatemartin]

Great lesson. Lovely to the fun your having with your son.

[chaiyya]

Hi Chandoo, Im glad ur channel appears to my youtube. Apart from PK, Leila & some other excel trainer, you are now 1 of my favourites.
Thanks for sharing

[atolanib]

Hi Chandoo, Thank you for this video, it is simple to follow. I used the formula but I keep getting a "0" at the end of my list and I think it's due to the blank cells before and after. What I would like to do is make the column dynamic for added values below rather than changing an already existing cell- Are you able to help?

[venkatiyer]

Great Sir ... thanks for teaching us ... the beauty is that you give multiple options for the learners to do with the excel they have .... Thanks a lot for considering everyone .... God Bless you and your son .... Junior Chandoo in making ....

[damianzubal]

is the method allow to create multiple colums dependent on previous column in table? for example
Vehicles, mark, brand, wheels, ?

[JacekPiszczek]

very helpful and nice explained. thanks

[dmanakell]

YOu just got yourself a new follower sir

[vamp]

can I use power query instead of pivot table ??

[vdfgkarthikvlogs]

Hi, Chandu
I have a doubt about 'Customers' used in

[warpathh]

What is that nominclature of "(customers[education])"? I want to make my data range be a whole column on another tab where a whole spreadsheet is loaded onto that tab and I need to make the same data validation process but how do I sort unique a column of data? I get an error when I try to select the column as the source =tabname!$C;$C (which is the nominclature when I select the Source as the whole column).

[JonasArnout]

@Chandoo, you should check out power query ...

[asifadnan]

I am facing a problem in excel dropdown list. Its like, I have to select a week from my dropdown list which will show up 3 previous years value of that same week in my chart (Example: If i select wk 24, the data should pop up in my chart is wk 24-2019, wk 24-2020 & wk 24-2021)but problem is, when i select a wk, its either shows wk data of yr 21 or 22/yr 19 or 22 something like that, not all 3 yr together. How to solve it.?? Can anyone help??

[drkesavsarma_singer]

Anna, koncham ardham ayindi, koncham kaledu...idi enduku, ekkada use avtundi... Telugu lo oka video cheyandi please...& Duplicate entries ela find out cheyali (remove cheste, total meeda impact chuspistundi kada). Ex: hospital lo monthly revenue or patient footfall ivvali managers ki... dialysis patients ki kuda bill chestam...weekly thrice vastunnaru...so, 12 times a month anukunna kuda, 3-4 patients (duplicate entries identity chesi teeseste) vallaki kuda bill chestam everytime.... duplicate entries teeseste - total revenue lo deduct avtundi kuda !?

[AnhTuan-fvkn]

Hi chandoo, 3:06 how can you hide, show data?

[anhnhatnguyet]

A drop-down list with 10 names. in line 1 choose name number 1, in line 2 do not show name number 1 because it was selected before. continue like that until the end. can this be done?