Re: Adding Arrows to ranking chart
Quote from Andy PopeHi Wigi,
Doesn't the use of <= prevent the ↔ from ever being true?
[vba]=IF(D3>AVERAGE(INDIRECT(ADDRESS(ROW(),5) &":" &ADDRESS(ROW(),COLUMN($N3)))),"↑",
IF(D3<=AVERAGE(INDIRECT(ADDRESS(ROW(),5) &":" &ADDRESS(ROW(),COLUMN($N3)))),"↓","↔"))[/vba]
Of course, sorry a typo. Take, respectively, ..... > ........ < ......
@ Cirerita:
you can adjust the formulas if you want to type the votes in the other order, so the latest score at the end of the row. My suggestion was one way to do it. With many votes, columns could easily be long. So inserting a new column D could be better than. Do as you prefer (but change the formulas if needed)
"having the column D as the latest scores forces me to write down those scores every week"
That's correct. Perhaps then, add the votes at the end of each row (also in case you only have a few new votes), but this changes the formulas. However, the basic picture suggested by Andy and worked out by me, remains.
Greetz,
Wigi