Forum Discussion
Get all values from a column based on criteria
Hi, I have a table and I am trying to get ALL values (duplicated or not) from a column in a different sheet based on criteria. The criteria are the highlighted columns in the first image below. ...
If you have Office 365 there is a FILTER function which I think will do what you want.
If you don't have 365 then see this youtube video which shows how to do this for older versions.
https://www.youtube.com/watch?v=fDB1Ktyhp3Y
Hope this helps!
regards,
Peter