Forum Discussion
conditional formatting with icon or colour that compare two columns in percentage changes?
Dear all : good day here, thanks for letting me to post the question here and thanks for your time on reading this. I have a matrix dummy here that I would like to ask how can I add ie : it...
lbendlin
Super User
Super UserDon't do separate tables. This should be all in one table.
| ItemID | Shop | Discount | Value |
| 12 | Shop1 | 78 | 444352 |
| 12 | Shop2 | 78 | 346760 |
| 12 | Shop1 | 80 | 20 |
| 12 | Shop2 | 80 | 20 |
etc.
My raw csv file comes in like this:
| ItemID | Shop1 | Shop2 | Discount |
| 12 | 10000 | 12000 | 78 |
| 12 | 9000 | 8000 | 78 |
| 10 | 80 | 109 | 80 |
| 9 | 900 | 100 | 90 |
so far and so on.
what is the best solution or direction I should look into? Thanks