List up unique value

[bidsinga]

Hello,

I have a list of poles and I need to make a order list of them. Per order I want to sort out the different poles based on their size and diameter.

I enclosed an example.

If it is possible I want to have Functions for all columns in the result table.

Thanks!Unique results.xlsx

[cbatrody]

Hi,

I have created a Pivot Table after going through the template you have uploaded. Please check if this suits your requirement (file attached).

Regards,
Chandra



Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.

[bidsinga]

Thanks for your quick response.

I think this will be the right option to solve this thread.

Only one thing: Is it possible to make the "pole range" column automatically adjustable? These values will changes based on how big he order is.

Thanks a lot!

Bas

[cbatrody]

Hi,

Yes, pole range column gets auto updated if you drag the cells further down.




Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue