I have attached a sample file for what I am trying to do...
In Sheet 1, I have a raw data list with columns [ID], [Name], [Representative], and [Date]. The sample file only has 11 lines of data, but actually I could have up to 1000 data lines.
In Sheet 2, I basically want to generate a list that matches the condition for [Representative]. For example, if the condition is "aaa", I want to generate a list from the raw data with only those that have [Representative] = aaa.
I've been playing around with INDEX, MATCH and ROW, but have not been able to find a solution. I would extremely appreciate if you could help!
Thank you in advance for your help.