How can I filter information from a list to a specific cell line.
Hello everyone!
I'm trying to create a tool to facilitate my calculations.
I have a dataset containing a lot of information about different metal profiles.
I want to find a way to isolate from the different groups considered to isolate the lines in a way that I can select the data in order to be able to automate the calculations. As shown in image 2, but in this case it is not possible to automate because the line will always be different.
I tried to create the pivot table but it didn't work.
Does anyone have any suggestions. Thanks.
[image_1]: https://ibb.co/D10Mt1N
[image_2]: https://ibb.co/tqGzTFM
Posted May 5, 2022, 5:37 PM UTC
12