I have following data :
Col A -Category Col B -Name
Teacher Jessie
Teacher James
Doctor Susan
Farmer Brayn
Farmer Michael
How can i do in list box or validation in order to:
once user click in column A, he can select Teacher, Doctor, Farmer in Col A
(something like filter, same category only appear 1 time),after select
Teacher, Column B will apear only Jessie & James (those name under doctor
category) to let user to choose

Finally,
w/sheet will have Doctor(Col A) Jessie(Col B if user choosed Jessie) & user
can key in figure in column C