Forum Discussion
Solved
Compare columns on 2 sheets and add a condition > 0 value
Hi experts! Will try to explain as clearly as I can: I need to understand if an incorrect rate (>0%) was applied to orders based on specific material numbers (which should have a 0% rate). sheet 1...
RosalieH The attached example may help you find a solution to your question. If not, you can perhaps upload the file you are working on, after having removed any private and confidential information.
You've already identified some of the most likely functions to be used to resolve your situation.
Beyond that, I think the most helpful thing you can do to help us help you is post a copy of the actual spreadsheet, so long as no proprietary or confidential information is in it. If that's the case, post something that resembles it, but has nonsense names and labels.
Otherwise we're forced to try to re-create the layout from your verbal description, and that is far less productive than working with the actual layout.