▲ 6 r/excel
Quickly filter values that satisfies multiple criteria in one column
I have the following set of data. Basically each loan has an unique ID and each loan can have multiple collaterals.
How to quickly filter loans that has multiple criteria e.g loans that has both property and vehicle as collaterals.
The real dataset has much more classifications and I have to do at least 10 combinations each time so I would like to find the quickest way (preferably something like a pivot table) to filter the values.
Thank you so much.
u/Aggravating-Plum-534 — 5 days ago