Ravi85
November 17, 2022, 4:29pm
1
Field by Field comparison and highlight which values has changed between 2 tables:
i ahve 2 tables with similar structure and need to compare and highlight where values has changed in the new table vs old table?
table a snapshotdate 14112022
table b snapshotdate 17112022
i need a result table with columns thats changed as 1/0 or yes/no is this possible?
Melissa
November 18, 2022, 2:17pm
2
Hi @Ravi85 ,
Welcome back!
Not much detail in your inquiry but see if this approach works for you, if not - supply a sample.
Do you often find yourself in dire need to compare two tables in Excel? In today’s blog post, we will create an Excel workbook that compares two tables and highlights the changes in a third table. You can load new versions of the tables, click...
Est. reading time: 14 minutes
Hello @Ravi85
Did the response above help solve your query?
If not, can you let us know where you’re stuck and what additional assistance you need? If it did, please mark the solution that helped you.
Thank you
Hello @Ravi85 ,
Due to the length by which this post has been active, we are tagging it as Solved.
Thanks to the contributors of this post @Melissa
For further questions related to this post, please make a new thread. Please feel free to reopen this thread if anyone would like to answer the pending inquiry above.
Thank you