Hello everyone,
I have spent quite a lot of time trying to figure this one out.
I have excel with bunch of data, and I need to show data which is based on filtering. I need to, based on one data column, show filtered content of another column.
I can do this manually, but data source is dynamic, so I need a formula or macro for this thing...
One idea would be to represent unique elements of column 1, and then somehow filter column 2 based on content of column 1.
To make it simpler, here is a screenshot of what I am trying to do...
I have spent quite a lot of time trying to figure this one out.
I have excel with bunch of data, and I need to show data which is based on filtering. I need to, based on one data column, show filtered content of another column.
I can do this manually, but data source is dynamic, so I need a formula or macro for this thing...
One idea would be to represent unique elements of column 1, and then somehow filter column 2 based on content of column 1.
To make it simpler, here is a screenshot of what I am trying to do...
![123.png](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2FnwV0xc%2F123.png&hash=e4017be8f1e50a742cd4d2458c094f28)