Forum Discussion
How to determine if a range exists?
Hello, Thanks in advance for helping me out. Problem: Products that have multiple prices I have a spreadsheet that contains product numbers, the variants under this which each have a unique num...
Thanks for the reply!
I was able to replicate your Pivot Table Results and then added a column to calculate the difference between the ranges. This means I can easily filter out products that do not have any price ranges.
Do you have any ideas about how to incorporate the Next Price column too?
I thought about some Conditional Formatting rules + filtering that could work but the issue is that I am dealing with tens of thousands of products so I am hoping for something as automatic as possible.
You still have not provided your desired result in the workbook and how "Next Price" should be incorporated.