JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Gallery
Share
Explore
How to compare between tables or excel imports?
QM
Quentin Morel
Comparison Summarize
Modified Product
Added Product
Unmodified Product
Deleted Product
Modified Product
Added Product
Unmodified Product
Deleted Product
1
@
Product 3
@
Product 1
@
Product 5
@
Product 6
@
Product 2
@
Product 4
@
Product X
There are no rows in this table
MasterTable
MasterTable
Product
Project
Price
Still in updated ?
Product
Project
Price
Still in updated ?
1
Product 2
Project B
100
2
Product 3
Project B
200
3
Product 4
Project A
150
4
Product X
Project A
100
There are no rows in this table
Updated Table (Copied from Excel)
Updated Table (Copied from Excel)
Product
Project
Price
Modification
in Master Table ?
Same Price ?
Same Project ?
Product
Project
Price
Modification
in Master Table ?
Same Price ?
Same Project ?
1
Product 1
Project A
120
Product Added
2
Product 2
Project B
100
No Modification
3
Product 3
Project C
200
Product Modified
4
Product 4
Project A
150
No Modification
5
Product 5
Project B
90
Product Added
6
Product 6
Project A
50
Product Added
There are no rows in this table
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.