•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Finding and comparing values across two tables
I have two tables: one has the name for my products and it's correct value. The other contains the name of the products and the value at which said product was sent to a client.
I want to compare both tables and highlight any instances where the product was sent with the wrong value in the second one.
Edit:
As an example, in Table 1, the product A173 costs R$252,00.
In Table 2, I have multiple instances of this product, but on line 354 the second to last column doesn't match with Table 1's value. I want to highlight this line so I can quickly find it and adjust it.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#tables
#product
#compare
#value
#highlight
#wrong value
#correct value
#sent
#value mismatch
#instance
#costs
#instantiated
#client