Good afternoon,
Hopefully someone can help out as i am stuck. have a sheet with data that i would like to filter data out as i use multiple drop downs.
i have all the dropdowns setup with the formula's setup in the cells i need. the issue i run in to is i can only filter one thing and not multiple. below is the formula the filer:
=IFERROR(INDEX($A$2:$R$500,$U2, COLUMNS($AK$2:AK2)),"")
U2 is the first column used to filter. i also have X2, AA2, AD2, and AG2
any help would be greatly appreciated.
Hopefully someone can help out as i am stuck. have a sheet with data that i would like to filter data out as i use multiple drop downs.
i have all the dropdowns setup with the formula's setup in the cells i need. the issue i run in to is i can only filter one thing and not multiple. below is the formula the filer:
=IFERROR(INDEX($A$2:$R$500,$U2, COLUMNS($AK$2:AK2)),"")
U2 is the first column used to filter. i also have X2, AA2, AD2, and AG2
any help would be greatly appreciated.