Forum Discussion

draia's avatar
draia
Copper Contributor
Nov 12, 2024

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 RecentToday Count
15,054.29 10/30/2418607.14
4.57 10/10/244.57
6,692.13 10/30/246889.51
3,504.65 10/30/244191.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".

Resources