Forum Discussion
draia
Nov 12, 2024Copper Contributor
Excel functions for column compares
I'm new to Excel and want to find a function that compares one column to another and if the value goes
up sends me an indication (trend up) and if the value goes down (trend down). For example
Total Count | Most Recent | Today Count | |
15,054.29 | 10/30/24 | 18607.14 | |
4.57 | 10/10/24 | 4.57 | |
6,692.13 | 10/30/24 | 6889.51 | |
3,504.65 | 10/30/24 | 4191.37 |
If Total Count is larger than Today Count - return trend down indicator
If Total Count is less than Today Count - return trend up indicator
If Counts are equal - no trend indicator
Is there a function that can do this on Excel?
You can add a helper column that calculates the difference:
Use this to create a conditional formatting rule of type Icon Sets.
If you wish, you can hide the numbers by ticking the check box "Show Icon Only".
- draiaCopper Contributor
Thank you - that worked extremely well!