Register
Log In
Unanswered
Home
November 9, 2016
Offline
I NEED A FORMULA THAT WILL SHOW IMPROVING, CONSTANT, DROPPING.
THANKS VERY MUCH IN ADVANCE
Dashboards
June 25, 2016
Offline
Hi Meyanui
It would help if you can provide us your expected result. Without knowing that, I can only make a guess.
Please refer to the attachment for 3 types of comparison.
To show such progress, I would normally include a chart as it is easier to visualize. I would use a sparkline but I believe you are using Excel 2003 (since your file extension is xls) or below and this feature is not available.
Hope this helps.
Sunny
November 9, 2016
Offline
Thank you Sunny. Is there a possibility of putting the three averages and making a comment or the remark
Dashboards
June 25, 2016
Offline
Hi Meyanui
If you are referring to the result, then just cut which ever you want and paste it into column G (Remarks)
It would be good if you can give an example of what you expect the result to be.
Â
Sunny
Dashboards
Power BI
Power Query
April 21, 2015
Offline
I was thinking of some conditional formatting with the colors green (improving), yellow (constant) and red (dropping). But I'm not sure if this is available in the older Excel versions?
Dashboards
June 25, 2016
Offline
Hi Frans
As far as I can remember, Excel 2003 (I hope this is the version you are using) can support up to 3 conditions (plus a default, if none of the 3 conditions are met).
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Oh no a misunderstanding: I'm using 2013 and 2016/365, but I wondered because the guy who asked it probably used the 2003 version as you noticed yourself 🙂
For me no problems! Luckily!
Most Users Ever Online: 57
Currently Online: clark shao
11 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
