data validation / dropdown filter

[aarti_rto]

Hello Experts,

i have below data , "Name , Department & salary".

i need your help to apply filter in "D" with dropdown for Department i.e. if i select HR then below table should display only HR related details..

D
A	B	C
Name	Department	Salary
ABC	SCM	193
SAD	HR	418
DSGFGF	HR	697
DSAFDSGF	SCM	614
SAF	HR	258
AFDS	FI	136
ADF	SCM	273
GF	FI	753
RET	SCM	119
ET	SCM	786
ETR	FI	286
RYT	FI	431

 

[Peter_SSs]

Duplicate to: data filters

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.