Uploaded February 2015 | Updated September 2026, 12 minutes ago

---

Get my Excel file here: http://1drv.ms/1bYwrTa
Display the values you've selected in a filtered field.
Mr Excel solved this using VBA code: youtube.com/watch?v=_JEjXNckfF8
I solve it using formulas.
Both ways aren't easy but are possible if you really need to do this.

https:--twitter.com-KevinLehrbass
http:--www.myspreadsheetlab.com-