Forum Discussion
Can we compare values between two identical table and generate a new table with the differences?
I've attached the file with sample data, I'm okay with either a power query or a vba solution I have a total of two tables, 1: Minimum selling Price with just one fixed row 2: Price table, with ...
Nishkarsh31 I don't do VBA. In PQ you can dynamically identify the lower prices but you can't format them.
In the attached file I demonstrated the use of Conditional Formatting and sorted the table in descending order based on the Total column. This isn't really dynamic (i.e. will not automatically expand when you need to change the source data), but it's not that hard to set up either.