Forum Discussion
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?
2 Replies
Thank you - that worked extremely well!
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".
