Maybe a bit off-topic. But since you seem great in coding and stuff I was wondering if you could help me out.
I'm playing a bit with google spreadsheets and i would like the following.
If a clan member has more than (say 15m xp) then points should be counted up.
I managed to do this, but as soon I try to import the gathered clan xp from RuneClan it seems broken.
In my example.. When A3 (clan xp) is bigger than 15M it should grab the data from sheet 2, cell D3
=SUMIF(A3;">15000000";Sheet2!D3)
But when I import data from runeclan it is listed as: 14,059,487
Apparently I'm unable to change the "," or style so it can read it as 14m xp. Now it's some weird number and unable to see if a person has 15m clan of or not.
NVM already fixed it.
05-Jan-2015 18:24:37
- Last edited on
05-Jan-2015 18:39:47
by
Imp