Forums
HLF General Chat Lounge
Quick find code: 259-260-138-63809579
Singularity
said
:
Buying Korey help
On Google spreadsheets: how do you make it so it displays your current dry streak (if possible)? I.e. I want a cell to show how dry I am currently (by displaying the # of kills without an item)
I'm not really sure... You could probably do a countif thing and have it look for the item drop names, but you'd have to continually adjust it to the location of your last drop every time you get an item drop... Like..
Torva Platebody (=countif "Brews", "Herbs", "Rune ore" ......)
Rune ore - 1
Rune ore - 2
Brews - 3
Brews - 4
Brews - 5
Brews - 6
Brews (Am I jinxing you yet?) - 7
Brews - 8
Torva Platelegs - You'd have to move the start point of the countif thing to begin with this cell/drop, rather than where it formerly started (at the Platebody)
Blasty or someone who knows a ton about spreadsheet things would probably know how to have it automatically count it somehow, but that's the best I could think up
One must strive to increase in power,
but also in knowledge of how to wield that power.
Buying Korey help
On Google spreadsheets: how do you make it so it displays your current dry streak (if possible)? I.e. I want a cell to show how dry I am currently (by displaying the # of kills without an item)
-
THERA
CORDS.
- Music produced from the <3 -
I'm not really sure... You could probably do a countif thing and have it look for the item drop names, but you'd have to continually adjust it to the location of your last drop every time you get an item drop... Like..
Torva Platebody (=countif "Brews", "Herbs", "Rune ore" ......)
Rune ore - 1
Rune ore - 2
Brews - 3
Brews - 4
Brews - 5
Brews - 6
Brews (Am I jinxing you yet?) - 7
Brews - 8
Torva Platelegs - You'd have to move the start point of the countif thing to begin with this cell/drop, rather than where it formerly started (at the Platebody)
Blasty or someone who knows a ton about spreadsheet things would probably know how to have it automatically count it somehow, but that's the best I could think up
One must strive to increase in power,
but also in knowledge of how to wield that power.
-Zaros
Lady of Zaros
Proud Linkify user
- Become one of the Family!
04-Jul-2014 01:09:26
Quick find code: 259-260-138-63809579 Back to Top