Filter all the combinations entered from 2 columns.

[Sharath Shetty]

I have a data representing duct sizes in width and height in 2 columns and length in 3rd column for more than 100 rows. I want to filter them according to their width and height. Help me. My data looks like this

W H L
100 200 3
200 100 1
300 200 2
100 200 1
300 200 1

i want it to get filtered and look like this in the new sheet

W H L
100 200 4
200 100 1
300 200 3

 

[Fazza]

Re: Need help to filter all the combinations entered from 2 columns.

One way - a pivot table. Row fields of W & H, data field with SUM of L

Start with a cell in the data. ALT-D-P, hit RETURN three times & then drag fields to position. Format as you like

 

[Sharath Shetty]

Re: Need help to filter all the combinations entered from 2 columns.

One way - a pivot table. Row fields of W & H, data field with SUM of L

Start with a cell in the data. ALT-D-P, hit RETURN three times & then drag fields to position. Format as you like

Thank you very much for that. Any other solution is also welcome.