data validation with a filter

[rjmdc]

how do i do data validation list but add a filter to ONLY active in the status column?
validation list only uses column of name

 

[KRice]

I'm not clear about how your data are organized, but if I'm following correctly, I would do something like the following. Helper cells are created to hold the filtered list, which is then referenced by Data Validation. You can eliminate the TRANSPOSE wrapper if the filtered dropdown list serves only one cell or the same filtered list will satisfactorily serve multiple cells...the list will then spill down the column.

MrExcel_20220912.xlsx
	A	B	C	D	E	F	G	H
1	Name	Status		Choose Active Member		Filtered Helpers
2	Abe	Active		Cam		Abe	Cam	Eli
3	Bob	Not Active
4	Cam	Active
5	Dee	Not Active
6	Eli	Active
Sheet1

Cell Formulas
Range	Formula
F2:H2	F2	=TRANSPOSE(FILTER(A2:A6,B2:B6="Active"))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
D2	List	=$F$2#